RDS Oracle 19c database - Grant DBMS_XA

0

In an RDS Oracle 19c database, we try to give a user permissions to sys.dbms_xa with the admin user and it tells us "insufficient privileges" Command "GRANT EXECUTE ON SYS.DBMS_XA TO USER" Can you help us?

demandé il y a 2 ans348 vues
1 réponse
0

When you create an Amazon RDS for Oracle database instance, the default master user is created and granted the maximum user permissions on the DB instance with some limitations. Use this account for any administrative tasks, such as creating additional user accounts in the database. Because Amazon RDS is a managed service, SYS and SYSTEM users can't be used by default.

Please check this Knowledge Center Article : https://aws.amazon.com/premiumsupport/knowledge-center/rds-oracle-user-privileges-roles/

**Example: **

SQL> GRANT SELECT ON SYS.DBA_TABLESPACE_USAGE_METRICS to EXAMPLE-USERNAME; GRANT SELECT ON SYS.DBA_TABLESPACE_USAGE_METRICS to EXAMPLE-USERNAME * ERROR at line 1: ORA-01031: insufficient privileges

SQL> EXECUTE rdsadmin.rdsadmin_util.grant_sys_object( p_obj_name => 'DBA_TABLESPACE_USAGE_METRICS', p_grantee => 'ADMIN', p_privilege => 'SELECT', p_grant_option => true);


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