Re: Amendment to question.

From: Jasper Smith (jasper_smith9_at_hotmail.com)
Date: 08/23/05 

Date: Tue, 23 Aug 2005 22:06:15 +0100

You can't deny anything to a sysadmin - they can literally do anything on
the instance and any other permissions are ignored 

-- 
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"jaylou" <jaylou@discussions.microsoft.com> wrote in message 
news:45188460-768D-4806-9F6F-A9A53B9AC84A@microsoft.com...
> Is there a way to remove the rights to add a new server login from a sys
> admin server role member?
>
> TIA,
> Joe
>

Relevant Pages

  • Re: Granting EXEC to all my user sprocs in one hit
    ... Jasper Smith (SQL Server MVP) ... >> Jasper Smith ... >>> I'm detaching the live copy and copying the files across to dev ... >>> set the permissions. ...
    (microsoft.public.sqlserver.security)
  • Re: permissions required for executing CDOSys stored procedures
    ... and if the user is db_owner in master he also can execute sp_OA ... he is by default member of the sysadmin ... sysadmin and who has not been granted specific execute permissions on the ... I don't know what version of SQL Server you are using, ...
    (microsoft.public.sqlserver.security)
  • Re: permissions required for executing CDOSys stored procedures
    ... properties of the sp_OACreate extended stored procedure has a permissions ... With SQL Server 2000 Enterprise ... Apparently only members of the sysadmin role can ... these stored procedures, however, the sql login for this application is ...
    (microsoft.public.sqlserver.security)
  • Re: permissions required for executing CDOSys stored procedures
    ... he is by default member of the sysadmin server ... role on the SQL Server database unless steps are taken to prevent that. ... sysadmin and who has not been granted specific execute permissions on the ... it is possible to GRANT EXECUTE ON sp_OACreate TO ...
    (microsoft.public.sqlserver.security)
  • Re: Sharepoint index problems in SQL Server.
    ... The Administrator account is a sysadmin and have all the access to all the ... > database is master and language US_English? ... >> I've set back the account localsystem for both SQL Server and Microsoft ...
    (microsoft.public.sqlserver.fulltext)