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 |
|
robg69
Starting Member
41 Posts |
 Posted - 2003-09-30 : 12:50:12
|
| Isn't giving a user db_datareader and db_datawriter rights the same as selecting all of those boxes for select, insert, update, delete? Also, does this affect views and execute rights on Stored Procs?Thanks! |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-09-30 : 12:56:16
|
| From Books Online:db_datareader Can select all data from any user table in the database. db_datawriter Can modify any data in any user table in the database. Not sure if this applies to views. It does not apply to stored procedures.Tara |
 |
|
|
|
|
|
quick question about rights