ansible-oracle-modules icon indicating copy to clipboard operation
ansible-oracle-modules copied to clipboard

Published 20 hours ago • verified publisher icon oravirt

With_Item questions

Open anandsolomon opened this issue 5 years ago • 1 comments

I running these 2 statements from a sql script and it fails with ORA-00922: missing or invalid option. I am using oracle_sql module.

Create ROLE SQLDEVELOPER_ROLE NOT IDENTIFIED ;

begin rdsadmin.rdsadmin_util.grant_sys_object ('ALL_USERS','SQLDEVELOPER_ROLE','SELECT'); END; /

anandsolomon avatar Feb 04 '20 17:02 anandsolomon

You cannot grant a select on a role. See https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/GRANT.html#GUID-20B4E2C0-A7F8-4BC8-A5E8-BE61BDC41AC3__I2183500.

Kind Regards, Dietmar

duhlig avatar Mar 06 '20 21:03 duhlig