Re: Can I deny select permission to members of Sysadmin role

From: Lan Lewis-Bevan [MS] (lanlb@online.microsoft.com)
Date: 07/10/02 

From: lanlb@online.microsoft.com (Lan Lewis-Bevan [MS])
Date: Wed, 10 Jul 2002 20:24:38 GMT

If you really need to prevent sa from performing certain tasks, you may
consider re-configuring your SQL server to use "Windows Authentication
Only" security mode. So sa will not be able to login and you can assign
permissions to other NT users individually.

Thanks.

Lan Lewis-Bevan (MS SQL Support)

This posting is provided "AS IS" with no warranties, and confers no rights.

Are you secure? For information about the Strategic Technology Protection
Program and to order your FREE Security Tool Kit, please visit
http://www.microsoft.com/security.

Relevant Pages

  • RE: Block Admin access to my data
    ... consider re-configuring your SQL server to use "Windows Authentication ... Only" security mode. ... leaving sa with all the un-removable rights. ... Still, you need to pay attention to your SQL service/agent accounts, since ...
    (microsoft.public.sqlserver.security)
  • RE: Block Admin access to my data
    ... consider re-configuring your SQL server to use "Windows Authentication ... Only" security mode. ... leaving sa with all the un-removable rights. ... Still, you need to pay attention to your SQL service/agent accounts, since ...
    (microsoft.public.sqlserver.security)
  • Re: Troubleshoot connecting client to SQL Server instance on a server
    ... an advanced product, such as SQL Server, works as you expected. ... A server running Windows Small Business Server ... SQL Server security (Authentication mode and logins). ... use Windows security mode for the SQL Server/Express. ...
    (microsoft.public.access.adp.sqlserver)
  • Re: SQL 2000 TIMEOUT ERROR WHEN TRYING TO CONNECT USING C#
    ... make sure it does accept username/pasword pair (that is, ... SQL Server allows remote access. ... Server has mixed security mode enabled (by default installed, ...
    (microsoft.public.dotnet.general)
  • Cannot add new NT login
    ... When adding a new login, ... sp_grantlogin) on a Security mode SQL Server of Windows Only, ... Windows NT user or group 'PUSNJLP\bostrke1' not found. ...
    (microsoft.public.sqlserver.security)