Smurfy Posted August 11, 2022 Posted August 11, 2022 Hello I have a database colleague trying to access the entity explorer. She needs this for the power BI work she is doing. The have the reporting admin plus a bespoke role (helped by @Victor) Called Entity viewer. However, when they click on some of the tables they get an error saying they need the permission "get database schema" Which thy already have. They can access some tables but not others Attached is the list they cant get access to and also a screenshot of the error and the "bespoke" role they have - like I mentioned they have the reporting admin standard role too. EntityErrorsList.txt
James Ainsworth Posted August 11, 2022 Posted August 11, 2022 Hi @Smurfy I would probably look to see what Service Manager roles they have. Data can still be protected based on the applications that you have access to. I see that there is a Service Manager icon in the left hand menu bar, so they to have some rights, but it might be minimal rights like Self Service or just Asset Management. Off the top of my head, I'm not sure which particular Service Manager roles they would need. Are you able to show us which SM roles they have?
James Ainsworth Posted August 12, 2022 Posted August 12, 2022 Hi @Smurfy Most likely not related, but you have the Basic User role against this user. As they have access to Service Manager, this would suggest that the they are a Full User and not a Basic User. I would recommend removing the Basic User role.
Smurfy Posted August 19, 2022 Author Posted August 19, 2022 Thanks James I didn't set the originals up - I think they gave basic to everyone Ive removed from our database collegue and will let you know the outcome. (she's not back until September)
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now