dwilander (10/22/2013)
Are you talking about application access to a database, an agent job, or ??? We generally create windows service accounts for both unless an application vendor has a specific need.Give us some details, you'll likely get a better answer.
actually at client side they are going to use third party software for aduit purpose.that 3 part has provided us with document according to which i have to carry down following steps
To collect events using a non-administrative SQL Server 2005/2008 database account:
1 Create a new database user account called sqlaudit.
2 Set the default database of this user to master (from the User Mapping tab, check the box in the Map column for the master database).
3 Grant this user (sqlaudit) Connect, Execute, and Select permissions.
4 Enable the proxy account to the same user (sqlaudit). (SQL Server -> Properties -> Security ->enable proxy account)
5 Go to SQL Server -> Properties -> Permissions and grant the user permission to Alter trace
can you plz guide on steps 3 and step 4
reagrds
Anoop