By using AWS re:Post, you agree to the Terms of Use

Oracle sys.utl_recomp grant permission to user

0

Is it possible within AWS RDS Oracle to grant sys.utl_recomp permission to a user?

exec utl_recomp.recomp_parallel(8);

The command does work as master user for the database, but I need to be able to grant permission to execute this command to another user. I've not been able to find information on how to complete this task. The command tasks page for AWS shows how to assign sys objects, but it doesn't work for the package utl_Recomp.

All help appreciated.

Topics
Tags
asked 3 years ago152 views
2 Answers
0
Accepted Answer

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

answered 3 years ago
0

Thanks Michael, sometimes I get so deep in the weeds I cannot see the answer.

Appreciated.

answered 3 years 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