SQL Server Schema Object Permissions List

SELECT Execute a SELECT query against the securable
INSERT Execute a INSERT query against the securable
UPDATE Execute a UPDATE query against the securable
DELETE Execute a DELETE query against the securable
EXECUTE Execute a procedural object
CONTROL Provides all permissions available on the object
TAKE OWNERSHIP Take ownership of the object if needed
CREATE Create an object
ALTER Modify an object

About Buja Atdhe

CEO of the platform
Gallery | This entry was posted in SQL Server 2008 and tagged , , . Bookmark the permalink.

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