Dietmar Uhlig comments

Repositories
Issues
Comments

Results 5 comments of


                                            Dietmar Uhlig

System password not correctly set when creating a DB

My solution is in https://github.com/duhlig/ansible-oracle-modules/commit/3baab32b9d7127aae17a47cc84feb52bd19f7e76 which is the content of https://github.com/duhlig/ansible-oracle-modules/tree/pr_dbcreate_systempw.

is "grant select on sysobject with grant option" currently not supported?

Hi Werner, I didn't use oracle_grants before, just checked the code. If I'm correct neither grant option for object privs nor admin option for sys privs is implemented. Adding the...

With_Item questions

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

Use of / as sysdba

Perhaps you could try oracle_slqdba, see PR #124. KR, Dietmar

New module oracle_sqldba for "sqlplus / as sysdba" and catcon.pl

No problem. There's no rush. KR, Dietmar