Post reply

Appling DENY object permissions to a Database

  • October 13, 2005 at 7:09 am

    #90218

    I have a Custom Database role that I want to deny several object permissions to for all objects in the DB. Can I do this in one query instead having to specify every single table/object?  Even though this doesn't work this is what I am trying to do:

     

    DENY  update,insert ON  *.Database TO CustomDatabaseRole

    Thanks for the response!

  • October 13, 2005 at 8:07 am

    #597094

    There is a script on this site that you can modify to do what you want...







    **ASCII stupid question, get a stupid ANSI !!!**

  • October 13, 2005 at 9:29 am

    #597126

    Thanks sushila will check it out!

  • October 13, 2005 at 9:36 am

    #597129

    Would adding CustomDatabaseRole to db_denydatawriter accomplish the same thing?

Viewing 4 posts - 1 through 3 (of 3 total)

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