2개 답변
- 최신
- 최다 투표
- 가장 많은 댓글
1
Hi there!
The master user in RDS Oracle should be direct-granted execute privileges on SYS.UTL_RECOMP, so it can grant the privilege to other users via the GRANT statement. For example,
grant execute on sys.utl_recomp to otheruser;
It can also be granted using the RDSADMIN_UTIL package as described at https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/Appendix.Oracle.CommonDBATasks.System.html#Appendix.Oracle.CommonDBATasks.TransferPrivileges (note, you will need to specify the grantee username in upper case with this command).
exec rdsadmin.rdsadmin_util.grant_sys_object('UTL_RECOMP', 'OTHERUSER', 'EXECUTE');
Hope this helps. Thanks!
Michael
답변함 5년 전
0
Thanks Michael, sometimes I get so deep in the weeds I cannot see the answer.
Appreciated.
답변함 5년 전
관련 콘텐츠
- AWS 공식업데이트됨 2년 전
- AWS 공식업데이트됨 2년 전