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 |
|
priyaram
Yak Posting Veteran
82 Posts |
 Posted - 2005-06-08 : 16:05:29
|
| hii am having an question.if i try to execute the stored procedure againt user1,then it's displaying his rights againg the tables he is having.but the same procedure if i run againt another user, i am getting an error msg asServer: Msg 15330, Level 11, State 1, Procedure sp_helprotect, Line 346There are no matching rows on which to report.My question is the result will be displayed only that user is having some grant permissions??but if i check against his login for user 1 who is having some rights againt some table, he is having only "public", and "db_datareader" access.but he is hacing some more rights.is there any way to find out what rights the users are having??since i am an new DBA , i am posting this .thanks |
|
|
chetancool
Starting Member
34 Posts |
Posted - 2005-06-09 : 08:59:19
|
| Hi..I hope this will help you.Open Enterprise Manager, click on the default instance and expand security.Click on Login. It will list all the logins in that server.Select any loginid. It will show properties of that particular loginid. In that properties, check server roles & database access tab for login id's rights in the pre-defined roles & rights.Keep Smiling. |
 |
|
|
|
|
|
sp_helprotect