Page 2 of 2

Re: MS SQL Monitoring

Posted: Fri Jan 29, 2016 3:28 am
by raamardhani7
jomann wrote:Does the user only have permissions for a specified table? There are some commands that read from the internal MS SQL tables that may require special permissions.
Hi Jomann,

Our DB team ad given us access to DB_OWNER access for our id. Is there any specific privileges that we need to have for running the commands. If so, could you please share me the list of permissions that needs to be given.. thanks.

Re: MS SQL Monitoring

Posted: Fri Jan 29, 2016 10:48 am
by lmiltchev
Here's an example of permissions of my "test" user:
example02.PNG
example03.PNG

Re: MS SQL Monitoring

Posted: Mon Feb 22, 2016 4:28 am
by raamardhani7
This is working fine now, this thread can be closed. thanks a lot for everyone who helped me. :)

Regards,
Ram.