question

Daniel Ross avatar image
Daniel Ross asked

Security Audit script

We use another organisations database to host a database for us, and understandably, we would like to know that our data can be kept secure from the other organisations staff (we know that some of them do, and we have an arrangement for them). We don't have any sysadmin access to the server or the database, so we are going to ask that an audit report be produced on a regular basis. Things that we would like to know are; - What accounts have sysadmin access - What accounts have local server admin access (do we need to use xp_cmdshell for this, or is there another way?) - What accounts have any sort of access to our database Your help is very much appreciated.
sql-server-2008security
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
Sacred Jewel avatar image
Sacred Jewel answered
1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

excellent, just what I need. Thanks!
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.