1. Grant the db_datareader role to all the databases, including the master database.
2. Grant the following permissions: alter trace, view server state, view database state and alter any event session.
Syntax:
use master;
grant alter trace to <new_user>;
grant view server state to <new_user>;
grant view database state to <new_user>;
grant alter any event session to <new_user>;
Replace <new_user> with the username of the newly created user.
e.g. If the new user name is appms, use that in place of <new user>
use master;
grant alter trace to appms;
grant view server state to appms;
grant view database state to appms;
grant alter any event session to appms;
Comments
0 comments
Please sign in to leave a comment.