May 22, 2020 at 9:48 am
Hello,
I have an issue with 2 users who have access to all the db's but two of those db's they get an error when accessing objects
i have doubled check their permission it has no deny db reader or writer all are db_owner, when i grant them sysadmin as a test it works. Any idea
It's better to fail while trying, rather than fail without trying!!!
May 22, 2020 at 10:20 am
I don't think you can assign permissions directly on the hidden mssqlsystemresource database. You'll need to assign a server-level permission to the user - possibly something like VIEW SERVER STATE.
John
May 22, 2020 at 10:35 am
do they have read access to master?
we had this recently on a 2012 box and changing user permissions to be ssis_admin, they couldn't run the ssis reports without getting errors with mssqlresource databases, granting read to master was a dirty fix to solve the issue.
May 22, 2020 at 12:27 pm
No permission on master but i will give it a try and feedback if all working
It's better to fail while trying, rather than fail without trying!!!
May 22, 2020 at 5:46 pm
Hello,
I have an issue with 2 users who have access to all the db's but two of those db's they get an error when accessing objects
i have doubled check their permission it has no deny db reader or writer all are db_owner, when i grant them sysadmin as a test it works. Any idea
A larger question would be... why do you have low priv'ed users that need to examine query store?
--Jeff Moden
Change is inevitable... Change for the better is not.
May 22, 2020 at 6:23 pm
No permission on master but i will give it a try and feedback if all working
According to the documentation, they need view database state permissions:
sys.query_store_runtime_stats (Transact-SQL)
Sue
May 22, 2020 at 7:25 pm
They are not viewing query store, this is from a user db which they have db_owner permission but below erro
It's better to fail while trying, rather than fail without trying!!!
May 27, 2020 at 6:05 am
Granting access to the master db it didn't work
It's better to fail while trying, rather than fail without trying!!!
Viewing 8 posts - 1 through 8 (of 8 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