May 9, 2016 at 6:51 am
Hi
I have a set of users who have been given the SQL AGent Operator's role in MSDB.
They still cannot open jobs to see them.
But if I give them SA privilege, they can see it.
If i make SQL Login for them, they can see it.
Their trusted login can access MSDB without any problem.
So it is not an AD issue.
Nobody on google seems to have any answers on this either.
Paresh Motiwala Manager of Data Team, Big Data Enthusiast, ex DBA
May 9, 2016 at 12:55 pm
Granting roles in databases does not grant them access to the server. Give them an AD group, if they don't already have one and grant that group access to login to the server....
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy