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

0

There are users who want to keep accessing tables created by a specific user in the future.

So is it possible to give full access to a specific user's table to another specific user?

And can you give the user admin privileges?

joker
demandé il y a 2 ans264 vues
2 réponses
1
Réponse acceptée

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!

Joseph
répondu il y a 2 ans
1

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.

https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/Oracle.Concepts.limitations.html#Oracle.Concepts.dba-limitations

AWS
répondu il y a 2 ans

Vous n'êtes pas connecté. Se connecter pour publier une réponse.

Une bonne réponse répond clairement à la question, contient des commentaires constructifs et encourage le développement professionnel de la personne qui pose la question.

Instructions pour répondre aux questions