Home > Query, SQL > BISQL # 78 – How to Check All presents SQL Server Rights ,Permission and Right

BISQL # 78 – How to Check All presents SQL Server Rights ,Permission and Right

December 16, 2011 Leave a comment Go to comments

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 :

image

Various Data Base Rights

Following script for Database rights

USE AdventureWorks;
SELECT * 
FROM fn_my_permissions('AdventureWorks', 'DATABASE'); 
GO

output for above result :

image

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:

image

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

Link Resource Website

Advertisement
Categories: Query, SQL
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

Gravatar
WordPress.com Logo

You are commenting using your WordPress.com account. ( Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. ( Log Out /  Change )

Cancel

Connecting to %s

%d bloggers like this: