Friday, April 27, 2012 9:23 AM
I am looking all users, permissions & Roles on a database, guys any body please provide best script for this.
Thanks in advance.
Friday, April 27, 2012 10:24 AM
can you please See the below thread-
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.
Friday, April 27, 2012 12:13 PM
visit Following thread in-order to get roles and permission
Mark as Answer If Reply Was Helpful
Technical Lead @ Simplion Technologies
Blog : www.dbsimplified.com
Thursday, May 03, 2012 4:47 AM
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.
Thursday, May 03, 2012 5:56 AM
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)
- Marked As Answer by Peja TaoModerator Tuesday, May 08, 2012 8:23 AM