Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Purpose of a role in the database

user545194Jun 13 2023 — edited Jun 13 2023

Oracle 19c SE2

The purpose of a role in the database is the separation of concerns. A role should hold mainly object privileges and not system privileges if I am not mistaken.

According to the Database Security Guide, 19c

12.7 Advantages of Using Roles to Manage Application
Privileges

Grouping application privileges in a role aids privilege management …

Probably the answer to my own question: System privileges are granted to a user and not to a role, because each user might require different privileges?

Nevertheless, feedback appreciated. Thanks!

Comments
Post Details
Added on Jun 13 2023
14 comments
1,142 views