1.db_datareaderto all the databases. Including master database.
2. grant alter trace, view server state, view database state and alter any event session permission.
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 newly created username.
Example: Let's consider the newly created user name is appms
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.