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 |
sanjit
Starting Member
1 Post |
Posted - 2007-05-21 : 03:24:17
|
I need to grant read permission to a user on all tables of all databases in the server. I have created a login for the user. Not I am finding problem while trying to grant select permission on all tables of all database in the server, Can anybody help me. I have large number of databases so i cannot grant permission individually. |
|
Westley
Posting Yak Master
229 Posts |
Posted - 2007-05-21 : 06:02:25
|
you can grant the rights for the new user to be the db_datareader role, so it will have select permission for all tables. As for generating the script, can use the sysdatabases in master to help. |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-05-28 : 16:27:20
|
Anyone to delete choooper's posts? |
|
|
|
|
|