Yeah yeah, you can argue with me about backward compatibility, but I’m so glad someone snuck this into 12c…
11.2
SQL> grant resource, connect to demo identified by demo;
Grant succeeded.
SQL> select privilege
2 from dba_sys_privs
3 where grantee = 'DEMO';
PRIVILEGE
----------------------------------------
UNLIMITED TABLESPACE
12.1
SQL> grant resource, connect to demo identified by demo;
Grant succeeded.
SQL> select privilege
2 from dba_sys_privs
3 where grantee = 'DEMO';
no rows selected
Man! AT LAST!!!!!!!!
Awesome! 🙂
But the real question is “Why RESOURCE role still exists?”.