My Oracle Support Banner

RESOURCE Role In DBA_SYS_PRIVS Does Not Include UNLIMITED TABLESPACE Privilege (Doc ID 114673.1)

Last updated on FEBRUARY 23, 2023

Applies to:

Oracle Database - Enterprise Edition - Version to [Release 9.2 to 11.2]
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Information in this document applies to any platform.


When displaying the privileges included in RESOURCE role from DBA_SYS_PRIVS, the UNLIMITED TABLESPACE privilege does not appear, though when granting this role to a user, the user automatically gets UNLIMITED TABLESPACE privilege. The list displayed from DBA_SYS_PRIVS can be misleading when you need to know which system privileges a user owns when being granted the RESOURCE role.


The audience for this document is intended to be DBAs and software developers.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.