With_Item questions

[anandsolomon]

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]

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