search

oravirt / ansible-oracle-modules

Oracle modules for Ansible
MIT License
209 stars 158 forks source link

With_Item questions #133

Open anandsolomon opened 4 years ago

anandsolomon commented 4 years ago

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; /

duhlig commented 4 years ago

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