Post reply

db_datawriter permissions

  • May 25, 2007 at 10:58 am

    #92587

    I have granted a sql user db_datawriter permissions on a database (SQL2k+sp4). Insert to a table works fine but update and delete fail with the error 'SELECT permission denied on the object'. Does db_datawriter needs db_datareader permissions too for update/delete to work ? Per bol, db_datawriter - can Add, change, or delete data from all user tables in the database. Further I noticed that it fails only when I specify a where clause in the update or delete from the table. Is this how it works on SQL Server 2K ? Can anyone clarify on this. Thanks.

  • May 30, 2007 at 9:45 am

    #709720

    Deleting and updating with a WHERE clause requires that the data be readable so the correct rows can be removed or modified.  It seems odd, but db_datawriter does not grant permission to select from database objects so, yes, the user must also either be a member of db_datareader or have specific SELECT permission on the objects to be modified.

    Greg

    Greg

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

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