In a Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production I'm trying to assign the CREATE SESSION
privilege to a custom role MYROLE
and then assign MYROLE
role to MYUSER
user.
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.
EDIT:
I think that my issue was related to the fact that MYUSER
hadn't a DEFAULT ROLE.
CONNECT
role does exactly the same thing.