Is it possible to give all privileges of a specific user to a specific user in aws rds oracle?

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!