[dba-SQLServer] Preventing System Admins From Accessing Database

David Emerson newsgrps at dalyn.co.nz
Fri May 3 20:02:29 CDT 2024


Hi Listers,

 

I have an SQL database which will be installed on a client's server.

 

Is there a simple way to prevent the client's server system administrators
from accessing the database (specifically changing security settings or
accessing the stored procedures and functions) but still allow me to have
full control over the database?

 

I am looking at pointers at this stage for me to investigate (eg if I
install a separate instance of SQL Server just for this application can I
have control over the security?)

 

Regards

 

David Emerson

Dalyn Software Ltd

Adelaide, Australia

 

 

 

 



More information about the dba-SQLServer mailing list