December 16, 2011 10:47 pm
Hi folks,
As I am not posting on Administrative Configuration aspect of SQL Server I thought of posting some scripts and explanation on Security,Rights,Logins and many more
In this post we are going to have explanation for following seniors
- Various permission in SQL Server
- Various Data Base Rights
- Various table Rights
Now lets try to understand each aspect with script and output
Various permission in SQL Server
Following script for permission
USE AdventureWorks; SELECT * FROM fn_my_permissions(NULL, 'SERVER'); GO
output for above result :
Various Data Base Rights
Following script for Database rights
USE AdventureWorks; SELECT * FROM fn_my_permissions('AdventureWorks', 'DATABASE'); GO
output for above result :
Various table Rights
Following script for table Right
USE AdventureWorks; SELECT * FROM fn_my_permissions('HumanResources.Employee', 'OBJECT') ORDER BY subentity_name, permission_name ; GO
output for above result:
Hope this Helps !!!!
Thanks for visiting my blog !!
Hope you will like this post on Check All presents SQL Server Rights ,Permission and Right.
If you really like reading my blog and understood at lest few thing then please don’t forget to subscribe my blog .
If you wan daily link and analysis or interesting link go to following website which will give @ your inbox please subscribe our following link resource blog
Where todays links are
Posted by Vishal Pawar
Tags:
Mobile Site | Full Site
Get a free blog at WordPress.com Theme: WordPress Mobile Edition by Alex King.