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 年前
相關內容
- 已提問 10 個月前
- AWS 官方已更新 2 年前
- AWS 官方已更新 2 年前
- AWS 官方已更新 6 個月前
- AWS 官方已更新 2 年前