In a Oracle Database 12c Enterprise Edition Release 220.127.116.11.0 - 64bit Production I'm trying to assign the
CREATE SESSION privilege to a custom role
MYROLE and then assign
MYROLE role to
GRANT CREATE SESSION to "MYROLE" GRANT "MYROLE" to "MYUSER"
When I try to connect I received:
ORA-01045: user MYUSER lacks CREATE SESSION privilege; logon denied
What am I missing?
If I give
CREATE SESSION grant directly to
MYUSER it works.
I think that my issue was related to the fact that
MYUSER hadn't a DEFAULT ROLE.