Users,Permissions,Roles
-
27. dubna 2012 9:23
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
Všechny reakce
-
27. dubna 2012 10:24
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.
- Navržen jako odpověď Peja TaoModerator 30. dubna 2012 3:12
- Označen jako odpověď Peja TaoModerator 8. května 2012 8:23
-
27. dubna 2012 12:13
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- Navržen jako odpověď Peja TaoModerator 30. dubna 2012 3:13
- Označen jako odpověď Peja TaoModerator 8. května 2012 8:23
-
3. května 2012 4:47
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
-
3. května 2012 5:56
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)
- Označen jako odpověď Peja TaoModerator 8. května 2012 8:23