SQL Server Performance Forum – Threads Archive

Permissions

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

---

]]>