Oracle sys.utl_recomp grant permission to user

Question

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.

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

Answer

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

Oracle sys.utl_recomp grant permission to user

Contenuto pertinente