Forum Discussion
What Role is active
I've found a simple solution with a role table, and in each role on the role table if added the RLS as =roletable[id]=1 (in the first) 2/3/4.
So I could see what role a user was having.
I messed up a bit with my own user being admin in the SSAS Azure server.
Have it clear now.
When you are talking about Roles, is this for Row Level Security?
Yes it was, but I have found a quite simple (silly) solution but it works.
Just defined a small table with the 4 roles into it, in each role I hardcoded =roleid=(testroles[id]=1) (or 2...4) and I could see what role was getting the user.
Because I noticed that some changes are not always directly ... I still have to dig a bit into this.
Main problem was probably that my normal user was also admin on the server, so I took it out and now I get it working, but was too late last night to continue....
I've found a simple solution with a role table, and in each role on the role table if added the RLS as =roletable[id]=1 (in the first) 2/3/4.
So I could see what role a user was having.
I messed up a bit with my own user being admin in the SSAS Azure server.
Have it clear now.
- That sounds like it will work