HI All,
 Due to sox audit complaiance issues, we cannot give full read write access
 to our production sql server 2005 databases to our developers.
 But our developers want to have atleast read access to sql server activity
 monitor and sql server JOB activity monitor.
 How can I give only read access to those two monitors?
 If I give read access to MSDB database then it will work?
 I think only sysadmin role has access to those monitors right?
 Please help on how to give read olny access to those monitors in sql server
 2005.
 Regards
 KumarYou just need to give them ProcessAdmin Server Role and in UserMapping
for MSDB give them SQLAgentReaderRole and SQLAgentUserRole
HTH,
Dineshsql
Subscribe to:
Post Comments (Atom)
 
No comments:
Post a Comment