I'm getting a permission denied error to a database I have access to via a role. I've checked the following things:
If I grant the perimission directly to my userid it works. This has happened sporadically in the past with other users. Not all users and not all roles. And some users appear to be just fine in a role and others will have this problem even though they are in the same role.
Is this a known problem?
when you login to sql assist, run "sel role". this will give you the role that you session has currently then you can try debugging from there.
When I run 'sel role' I get null. When I run the other one I get a role but not the one I'm expecting. A coworker was recently dropping roles, not the one I need, but this could still explain why things got weird.
So even if I have default role=all on my user, it is still possible to have no default role set in certain situations?
I reset my default role to all and it is now showing ALL when I run sel role. I think this has solved the issue, thank you!