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 |
|
whizsql
Starting Member
17 Posts |
 Posted - 2008-12-11 : 12:17:41
|
| Hi,I created a databse role with 'select' permission/securables to a number of tables in a database.I have a network group called SDRRPT, which is a member of the database role created earlier.And, I added my windows login to SDRPT network group.The purpose of this setting was to permit the users of SDRPT group to have read only/reporting access to the tables listed/secured under database role.During testing, I logged in with my windows login SQL Server 2005 client, I found a number of tables for whcih I haven't given permissions as part of databse role created earlier..I thought my login will have access to only those tables included in database role..Isn't that correct? Any idea on what has gone wrong with my setup?Also, is there any way to view all my login permission to all ojects under a database?Please help.Thanks ! |
|
|
X002548
Not Just a Number
15586 Posts |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-12-11 : 13:33:44
|
quote:
Originally posted by whizsql
is there any way to view all my login permission to all ojects under a database?Please help.Thanks !
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=111918 |
 |
|
|
|
|
|
Database role & permissions