- Newest
- Most votes
- Most comments
Hi there,
Object privilege management is the same either on-premise oracle or RDS oracle. There is no such privilege that grants access to tables of another user (especially that will be created in future). Rather we can create a role and grant the required object privileges to the role and then grant the role to the another user, but for future tables you need to grant the previlies once there are created. So we better way is to use a dynamic query to grant the privileges to the role and run/schedule the execution after objects are created on first user. You can refer below link for dynamic query: https://community.oracle.com/tech/developers/discussion/966693/grant-access-to-schema
Yes granting DBA role/any other admin role will work BUT it is NOT recommended process in terms of security.
Thank you!
If the user has been granted the object privilege with the WITH GRANT OPTION, the user can give the object priviledge to another user.
If the user has been granted the system priviledges CREATE USER, ALTER USER and DROP USER with the WITH ADMIN, the user can give the system priviledges to another user.
Details are in the following document : https://docs.oracle.com/cd/F19136_01/sqlrf/GRANT.html#GUID-20B4E2C0-A7F8-4BC8-A5E8-BE61BDC41AC3
And also you can use the DBA role on RDS for Oracle. The user granted the DBA role can give any priviledges to another user, but some priviledges are limited from DBA role. The details of the limitations are in the following.
Relevant content
- asked 3 years ago
- asked 2 years ago
- asked 3 years ago
- AWS OFFICIALUpdated 8 months ago
- AWS OFFICIALUpdated 3 years ago
- AWS OFFICIALUpdated a year ago
- AWS OFFICIALUpdated 4 months ago