RE: sql server start/stop security
Next message: culam: "disable local admin rights in sql server"
Date: Thu, 18 Nov 2004 17:04:34 GMT
Unfortunately there is not a way to prevent members of the local admins on
the SQL server machine from stopping and starting SQL Server. Even if you
could, they would be able to give themself the right back since they are
adminsitrators.
Rand
This posting is provided "as is" with no warranties and confers no rights.
Next message: culam: "disable local admin rights in sql server"
Relevant Pages
- Re: System Administrator Implied Permissions
... > sa login, it assigns it the System Administrator fixed ... > Now, given this, why does SQL Server ... in each database is always a member of the public and db_owner roles. ... Other sysadmin role members have the exact same ...
(microsoft.public.sqlserver.security) - Trust relationship issue?
... My problem is related to SQL Server. ... Many users are having access denied, even being members of a Windows group ... They can access the instance only if I explicitly add a login for each user. ... Can it be related to trust relationship? ...
(microsoft.public.windows.server.active_directory) - Trust relationship issue?
... My problem is related to SQL Server. ... Many users are having access denied, even being members of a Windows group ... They can access the instance only if I explicitly add a login for each user. ... Can it be related to trust relationship? ...
(microsoft.public.security) - Re: Could not save on existing DTS
... >Make them members of dbo role in msdb. ... Adding dbo membership in msdb is not relevant as by default all users ... DTS - http://www.sqldts.com PASS - the definitive, global community for SQL Server professionals ...
(microsoft.public.sqlserver.dts) - Re: Restricting Access priviledge on SQL2000
... You must have made the "Application-Administrators" members of the sysadmin role in SQL Server. ... Take them out of the sysadmin role, add them as users in the correct database, then make them members of the db_owner role in that database. ...
(microsoft.public.sqlserver.security) |
|
