Re: Security Question

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Dejan Sarka (dejan_please_reply_to_newsgroups.sarka_at_avtenta.si)
Date: 12/05/04 

Date: Sun, 5 Dec 2004 09:34:29 +0100

> What would happen if I were to just change the BUILTIN\Administrators
entry
> to deny access? Would those that are explicitly entered in SQL still have
> access?

No, deny goes over grants. Just remove the login, this shuld do. 

-- 
Dejan Sarka, SQL Server MVP
Associate Mentor
www.SolidQualityLearning.com

Relevant Pages

  • Re: Security Question
    ... to deny access? ... Would those that are explicitly entered in SQL still have ... that local admins are denied access? ... > adding a new administrator (add the login to the sysadmin server role), ...
    (microsoft.public.sqlserver.setup)
  • Re: SQL 2000 Security Question
    ... Simple question from someone who knows nothing about SQL. ... I deny access to Built-In\Administrators ... Taking your question at face value, if you had a user named, let's say, jsmith, and you make jsmith dbo of the pubs database, but then you define access-denied for jsmith to pubs, jsmith will not be able to connect to pubs. ...
    (microsoft.public.sqlserver.security)
  • SQL 2000 Security Question
    ... Simple question from someone who knows nothing about SQL. ... I deny access to Built-In\Administrators ... I add an account that is a local admin on the SQL box, and give it DB_Owner to various DB's that it should own, and be able to do whatever in. ...
    (microsoft.public.sqlserver.security)
  • Re: SQLDUMPER library error message (PLEASE HELP)
    ... which "provides the interface to backup/restore Microsoft SQL ... I'd go back to a Restore Point, but I don't know when installed the ... > an MS Office 2007 trial - or do a System Restore. ... you'll see an entry made just ...
    (microsoft.public.windowsxp.general)
  • RE: Access Sum in Query
    ... Ideally i could get them to make a SQL database for me, ... field entries all match to generate one entry in the new table from query ... (make-table query). ... the 4 fields that need to match, then sum the adjustment field, i get results ...
    (microsoft.public.access.queries)