[dba-SQLServer] Preventing System Admins From Accessing Database

[Gustav Brock]

Hi David

The obvious and simple method is to ask them to not do that.

Network and db admins are typically so busy that they for sure don't look for more work, and knowing that your database is your responsibility removes a potential new task, and they can set a check mark: Maintained by supplier.

That said, I would arrange for a separate instance. That will make installation, backup, and recovery, and future updating straight-forward.

/gustav

________________________________
Fra: dba-SQLServer <dba-sqlserver-bounces+gustav=cactus.dk at databaseadvisors.com> på vegne af David Emerson <newsgrps at dalyn.co.nz>
Sendt: 4. maj 2024 03:02
Til: AccessDSQL <dba-SQLServer at databaseadvisors.com>
Emne: [dba-SQLServer] Preventing System Admins From Accessing Database

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