I'm trying to grant Connect and Resource in Oracle, and I get an error that says that the role do not exist:
SQL> grant connect to MY_SCHEMA;
grant connect to MY_SCHEMA
*
ERROR at line 1:
ORA-01919: role 'CONNECT' does not exist
However, I check the roles and they exist:
SQL> select role from dba_roles;
ROLE
------------------------------
CONNECT
RESOURCE
Why I'm getting the error if both of the roles exist?