Jump to content

Recommended Posts

Posted

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.



image.thumb.png.75bf6d77161ea4a93901875535ea823f.png

image.thumb.png.b7199ec19d3ae9c75d86cbd4fb80a7a0.png

EntityErrorsList.txt

Posted

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?

 

 

Posted

Thanks James
This is what she has

image.thumb.png.807c74dbc5908a0c7907077d4fafb4ba.png

 

Posted

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.

 

 

Posted

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) 

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 account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...