how to access sys.user_history$ in aws oracle rds

0

how to access sys.user_history$ in aws oracle rds wanted to check history of a user and list previous stored encrypted passwords form the AWS ORACLE RDS( SE2)

asked 9 months ago296 views
1 Answer
0

Try,

begin
    rdsadmin.rdsadmin_util.grant_sys_object(
        p_obj_name  => 'USER_HISTORY$',
        p_grantee   => 'ADMIN',
        p_privilege => 'SELECT');
end;
/

Note: p_grantee is the schema or role that you want to grant the privilege to.

For more information on Granting SELECT or EXECUTE privileges to SYS objects please refer to the following link:

https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/Appendix.Oracle.CommonDBATasks.System.html#Appendix.Oracle.CommonDBATasks.TransferPrivileges

AWS
answered 9 months ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions