Revoking DBA role revokes UNLIMITED TABLESPACE from a user
Hi,Talking with some colleagues today I came across something I wasn't aware of regarding the UNLIMITED TABLESPACE privilege.
DB is 11.2.0.3
If you explicitely grant UNLIMITED TABLESPACE to a user, then grant the DBA role to the same user, and finally revoke the DBA role from the user, then the UNLIMITED TABLESPACE privilege is also revoked.
I found the Note "Revoking DBA or RESOURCE Roles Revokes UNLIMITED TABLESPACE from the User [ID 1084014.6]" describing this, saying "this is the expected behaviour."
But, unless I'm mistaken, I couldn't find in the documentation where this is stated as expected behaviour. In the 11g2 SQL Language Reference I can read the following about the REVOKE statement:
DB is 11.2.0.3
If you explicitely grant UNLIMITED TABLESPACE to a user, then grant the DBA role to the same user, and finally revoke the DBA role from the user, then the UNLIMITED TABLESPACE privilege is also revoked.
I found the Note "Revoking DBA or RESOURCE Roles Revokes UNLIMITED TABLESPACE from the User [ID 1084014.6]" describing this, saying "this is the expected behaviour."
But, unless I'm mistaken, I couldn't find in the documentation where this is stated as expected behaviour. In the 11g2 SQL Language Reference I can read the following about the REVOKE statement:
0