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 |
|
jmalathirao
Starting Member
9 Posts |
 Posted - 2007-11-29 : 12:38:15
|
| Hi All,For listing login details we have sp_helplogins 'LOGIN NAME'In the same way i want ti know for particular procedure.can any one help in this.Thanks in advance.malathi |
|
|
snSQL
Master Smack Fu Yak Hacker
1837 Posts |
Posted - 2007-11-29 : 20:24:20
|
| Take a look at the permissions() (SQL Server 2000) and fn_my_permissions() (SQL Server 2005) functions. |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-11-30 : 01:49:04
|
| You mean all users have permission on specific sp? Try sp_helprotect if so. |
|
|
|
srimathi.mani
Starting Member
3 Posts |
Posted - 2007-11-30 : 02:48:48
|
| Do you want to know the permissions associated to a particular procedure????Can u be much more clear!!Regards,Srimathi |
|
|
|
jmalathirao
Starting Member
9 Posts |
Posted - 2007-11-30 : 07:06:47
|
| sp_helprotect this perfectly helpfull.thanks a lot |
|
|
|
|
|
|
stored procedure permissions list