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.
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)
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)
Re: SQL Security & User-Level Access ... Because the users are going to be accessing the SQL Server through an .ade ... I'd like the users to be able to login to the SQL Server database using ... their username and password in the Members table. ... > It sounds like you have two security related items to consider. ... (microsoft.public.sqlserver.security)
Re: Sql Server login ... One method is to login to you laptop using a local Windows account....sysadmin role members.... You could also configure SQL Server to allow both Windows and SQL Server ... (microsoft.public.sqlserver.security)
