SQL Server Permissions Hierarchy

Database Security - @SeniorDBA

The SQL Server Database Engine manages the security hierarchy with a collection of entities known as securables. These entities can be secured with permissions within the database engine.

The most prominent securables are servers and databases, but discrete permissions can be set at a much finer level. SQL Server regulates the actions of principals on securables by verifying that they have been granted appropriate permissions.

The following illustration shows the relationships among the Database Engine permissions hierarchies.

Database Security - @SeniorDBA

For a poster sized chart of all Database Engine permissions in pdf format.

Advertisements

Leave a Reply

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

WordPress.com Logo

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

Twitter picture

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

Facebook photo

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

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s