Users,Permissions,Roles

Question

Hi Team,

I am looking all users, permissions & Roles on a database, guys any body please provide best script for this.

Thanks in advance.

Tx

---

subu

Answer 1

can you please See the below thread-

http://social.msdn.microsoft.com/Forums/en-US/sqlsecurity/thread/678c5758-7272-48da-9c7d-50b4b49c9615

---

Rama Udaya.K ramaudaya.blogspot.com ---------------------------------------- Please remember to mark the replies as answers if they help and unmark them if they provide no help.

Answer 2

visit Following thread in-order to get roles and permission

http://www.dbsimplified.com/2011/10/view-user-wise-permissions-in-sql.html

---

Mark as Answer If Reply Was Helpful
Thanks
Kuldeep Bisht
Technical Lead @ Simplion Technologies
Blog : www.dbsimplified.com

Answer 3

Hi Team,

the above scripts i should not get exact results.

here i m looking each user permissions and roles  of each user database can you guys any body please help me on this.

Really thanks in advance.

---

subu

Answer 4

Hello Subu,

The below script will give all the users present in a database, along with the login details, user permissions, default database, default schema, etc. Hope, this may help :)

USE [TestDB];
GO
EXEC sp_helpuser;
GO

---

SKG: Please Marked as Answered, if it resolves your issue. (b: http://sudeeptaganguly.wordpress.com)