SQLTeam.com | Weblogs | Forums

Need an audit account


#1

We have a sql server database hosted on a vendor site. We were ask to do audit.
What kind of permission should i request from the vendor for audit purposes?
We need to know the following:

  • when an user account was create/deleted/modified
  • when objects were create/deleted/modified

i am thinking of an admin account but read only.

thanks.