Post reply

Deny drop tables but permit drop procedures

  • May 5, 2011 at 8:03 am

    #239100

    Dear, I have a difficulty, I hope someone can help me on this:

    In SQL 2005, how I can give permissions to a user so you can create, delete, edit stored procedures and functions? ... but can not create, modify or delete any table.

    If I assign the ALTER permission, it may delete a table. If denied, the user will not be able to edit stored procedures.

    Thanks in advance ...

    Greetings

  • May 5, 2011 at 8:19 am

    #1320443

    Leonard see this post from yesterday, where someone posted the same question:

    http://www.sqlservercentral.com/Forums/Topic1103306-146-1.aspx#bm1103313

    To prevent the DROP of objects,where the user normally might have permissions to do so, you'll have to use a Database level DDL trigger. in that thread i posted an example of one.

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply