Permissions | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive


Hi Everyone,
I know it kind of stupid quastion,but i got it, ok here is that how could we (i) know what or which permissions are granted to user (or myself) on server side or on userdatabases.
Thanks in advance SRJ2005
You can right click on the username under Security and see the properties. ***********************
Dinakar Nethi
SQL Server MVP
Thank you it works.Is there anyway see this through t-sql. SRJ2005
SP_helplogins —-> instance level
SP_helpusers —-> database level
SP_helprotect —-> object level ——————
Bug explorer/finder/seeker/locator
thank you. SRJ2005