Post reply

Block Inserts, Update

  • January 9, 2006 at 12:45 pm

    #92551

    Hi, I need to denied writes, updates permision for several database users.

    All users have SA as Server Role, I know this is wrong but it's the way that the  application works.

    I'm trying to grant db_denydatawritter but the user is modifying records.

    How can I block writes, updates for users?

    Thanks for your help.

  • January 9, 2006 at 2:28 pm

    #613677

    You can't. Anyone in the sysadmin fixed server role maps into a database as dbo. The dbo user ignores permissions, including DENYs. The dbo user has access to all objects.

    K. Brian Kelley
    @kbriankelley

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

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