Jack Vamvas's Blog

Getting Started with Adobe After Effects - Part 6: Motion Blur

Upload Image

Close it

Select File

Learn about SQL Server DBA, SQL Server database performance,SQL Server optimisation,database tuning,t-sql,ssis

Browse by Tags · View All

Archive · View All

Home · Most Liked · Most Discussed · Fans (41) · Preferences

SQL Server – CONTROL SERVER

Feb 17 2011 7:38AM by Jack Vamvas

A login can be granted CONTROL SERVER rights,

USE mater
GO
CREATE LOGIN test WITH PASSWORD = ‘myPassword123’;
GO
GRANT CONTROL SERVER TO test;

CONTROL SERVER rights allows a login to do anything in SQL Server, but there is one subtle difference with sysadmin.

It is possible to explicitly DENY connect to the login with CONTROL SERVER right ,

DENY CONNECT TO test;

Members of the syadmin bypass the DENY

Republished from SQL Server DBA [65 clicks]. Read the original version here [32134 clicks].

Jack Vamvas

5 · 27% · 8528

Liked

Lifesaver

Refreshed

Learned

Incorrect


Like this
Post this to my facebook wall
Tweet this
This was a true life saver
Thanks, this helped me to refresh my memory
Very informative, I just learned something new
I disagree, this information is incorrect

Your Comment

Sign Up or Login to post a comment.