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 |
|
twayd
Starting Member
3 Posts |
 Posted - 2008-07-01 : 13:31:07
|
| hello all - i've got a question about the public role. ive defined a login on a sql server, and i see that is gets the public role by default. from what i've read that gives the ability to enumerate the database that are resident on that server. does that also give the ability to execute select statements against all db's?? if not, how would you go about building a special role for select-only capabilities across all db's on a server??thanks in advance |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-07-01 : 13:35:25
|
| The public role does not provide any permissions to objects. If you want select permission to be provided for a user, grant the user db_datareader role inside the database.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog |
 |
|
|
twayd
Starting Member
3 Posts |
Posted - 2008-07-01 : 13:37:48
|
| thanks, tara! that has to be done on each db, correct? is there a way to grant that privilege from a server level??? |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-07-04 : 21:43:17
|
| No, can't grant db access permission at server level other than adding login to sysadmin role. That's something you don't want to do. |
|
|
|
|
|
|
public role