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.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 How to know the permissions allowed to know

Author  Topic 

senpoly
Starting Member

19 Posts

Posted - 2007-09-03 : 01:37:01
hi

is any sp is there to know what are the permissions granted given to that particular user

please let me know

regards
senpoly

PeterNeo
Constraint Violating Yak Guru

357 Posts

Posted - 2007-09-03 : 02:04:09
hi,

use sp_helprotect, read BOL for parameters.

Peter.
Go to Top of Page

senpoly
Starting Member

19 Posts

Posted - 2007-09-03 : 05:46:37
thks peter
this is what i need


regards
senthil
Go to Top of Page
   

- Advertisement -