April 19, 2009 at 10:40 pm
Hi
In my server it has some Windows authenticated users
The users all are having sysadmin server roles
ALSO
They have the application roles
Is it securable to having the sysadmin roles to that users?
Is it necessary giving the sysadmin as well as application roles?
Plz let me
With regards
Lee
April 20, 2009 at 12:37 am
If the users have SYSADMIN no other permissions are checked; they super seed all permissions. In production environment no user other then service account, SA and DBA group should have SYSADMIN.
Thanks.
Mohit.
Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN[/url].
Microsoft FTE - SQL Server PFE
* Some time its the search that counts, not the finding...
* I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing. :smooooth:[/font]
April 20, 2009 at 1:13 am
Lee From Bangalore (4/19/2009)
Is it securable to having the sysadmin roles to that users?
Absolutely not. By giving sysadmin, you're giving them rights to do anything on SQL. Drop databases, delete tables, stop the service, etc
The recommendation for user permissions is the absolute minimum permissions that they need to do what they need to do.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
April 20, 2009 at 2:05 am
Hi
Thank you for all
With regards
Lee
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply