Prevent Adminstrator Group Access

From: Lionel Horn (lhorn_at_newsgroup.nospam)
Date: 05/27/05

  • Next message: Andy: "User roles/rights" 
    Date: Fri, 27 May 2005 08:36:08 -0700

    I have a stored procedure that I do not want administrators to run. I need
    to prevent the Windows group “BUILTIN\Administrators” from running the stored
    procedure.

    I have a stored procedure to view credit card information. Only select
    domain users need access to the data. Domain Administrators should not be
    able to see the data, though they can see everything else. My server is
    setup for mixed-mode authentication.

    Please advise if this is possible. Thanks! 

    -- 
Lionel Horn
  • Next message: Andy: "User roles/rights"

    Relevant Pages

    • Re: Prevent Adminstrator Group Access
      ... If you dont wanna move them out of the service administrators group you ... have to map the administrator to the database and deny the executing of the ... >I have a stored procedure that I do not want administrators to run. ... > domain users need access to the data. ...
      (microsoft.public.sqlserver.security)
    • Re: Prevent Adminstrator Group Access
      ... "Jens Süßmeyer" wrote: ... > "Lionel Horn" schrieb im Newsbeitrag ... >>I have a stored procedure that I do not want administrators to run. ...
      (microsoft.public.sqlserver.security)
    • removing windows group thats a database user
      ... When attempting to remove a windows group using the ... stored procedure xp_dropuser obtain the following error: ... article explaining this problem. ...
      (microsoft.public.sqlserver.security)