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!

Adding privileges to a role

user545194Dec 6 2022

Hi,
Quick question: We have a role that needs to be updated regularly whenever there is a new table in a specific schema. Do the privileges that already exist for that role have to be revoked first and re-granted so to speak or simply add, "GRANT SELECT ON new_table TO role_name;"?

This post has been answered by Frank Kulash on Dec 6 2022

Jump to Answer

Added on Dec 6 2022

#general-database-discussions, #sql

2 comments

90 views

2 mentions