Re: Deny access to all users (including Administrator and DomainAdmins) except SA?

Hi
Which vesrion of SQL Server you are using?
In SQL Server 2005 you can try DENY CONNECT TO...... or DENY VIEW DEFINITION
(For more details please refer to the bol)
SQL Server 2000
Remove everyone that you don't want rom an Administrator Groups
http://vyaskn.tripod.com/sql_server_security_best_practices.htm --------security
best practices




"Pradeep Pamidi" <pamidipradeep@xxxxxxxxxxx> wrote in message
news:%23dutfEoLGHA.1124@xxxxxxxxxxxxxxxxxxxxxxx
How can I ensure that databases in a SQL Server instance are accessible
(and manageable) ONLY through SA account or other accounts created by SA.
The Administrator or DomainAdmins of the box must be denied access to the
DB.

Real life scenario: We ship SQL Server DB along with our product. The DB
contains confidential/IP information and hence must not be accessible to
anyone except from the application layer (which maintains the required
credentials). MS Access DBs have a database password that could restrict
access to the DB. How do we achieve it in SQL?

Thank You,
PRadeep



.

Relevant Pages

  • Re: Column Level Permissions Security Issue
    ... role is granted SELECT rights as in "GRANT SELECT TO RWE", then a DENY ... When working with security in SQL Server it's imperative to understand ... discusses ownership chaining: http://www.sommarskog.se/dynamic_sql.html. ... there are users who have permission to access this ...
    (microsoft.public.sqlserver.security)
  • Re: Groups VS Users
    ... > The short question is why does SQL Server seems to deny access to a user ... Each group as slightly different permissions. ... access denied ACE will override all access allowed ACEs for the same ...
    (microsoft.public.sqlserver.security)
  • Re: How do I find I am administrator?
    ... Procedure" and "Create View" for your SQL server user using the ... DENY statement; ... In this case even if you are db_owner for a database you will not able to do ...
    (microsoft.public.sqlserver.connect)
  • Re: How do I find I am administrator?
    ... Procedure" and "Create View" for your SQL server user using the ... DENY statement; ... In this case even if you are db_owner for a database you will not able to do ...
    (microsoft.public.sqlserver.server)
  • Re: How do I find I am administrator?
    ... Procedure" and "Create View" for your SQL server user using the ... DENY statement; ... In this case even if you are db_owner for a database you will not able to do ...
    (microsoft.public.sqlserver.tools)