Resource Role in Oracle Database 26ai

RESOURCE role is a popular and famous built-in database role, historically its used to be granted to developers to enable them create objects in their working schema.

The built-in role has changed in the number of system privileges, to clarify more in 19c it consists of 8 system privileges:

In 26ai, more system privileges were added such as “create view” system privilege, total number is 15:

This is a good enhancement and much needed in 26ai release, it enables more empowerment for the developers ,and maintains the security through least privilege principle.

Leave a comment