Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
scelamko
Constraint Violating Yak Guru
309 Posts |
 Posted - 2005-09-01 : 10:48:20
|
| Guys, I have small question regarding roles and permissions in SQL Server. For user I have granted db_reader and db_writer roles but these roles does not allow user to delete from the tables, so to cover this up I gave individual delete rights on all objects. But my questions instead db_writer + delete permissions on all obejcts can I just give them db_ddladmin role to the user. I think it should take care of it.Please let me know your suggestions/comments in this regard.Thanks |
|
|
TG
Master Smack Fu Yak Hacker
6065 Posts |
Posted - 2005-09-01 : 11:12:29
|
>>these roles does not allow user to delete from the tablesThere must be another issue going on here. From Books Online:quote:
db_datareader Sees all data from all user tables in the database. db_datawriter Adds, changes, or deletes data from all user tables in the database.
db_datawriter allows data to be deleted from user tables. db_ddladmin allows the grantee to drop all objects in the database. That may not be what you want.Be One with the OptimizerTG |
 |
|
|
|
|
|
Roles and Permissions on Objects