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)

已提問 10 個月前檢視次數 312 次
1 個回答
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
已回答 10 個月前

您尚未登入。 登入 去張貼答案。

一個好的回答可以清楚地回答問題並提供建設性的意見回饋,同時有助於提問者的專業成長。

回答問題指南