How to make admin option=YES for DBA_roles in Oracle direct connector?By default role is assgined with Admin option=NO

[srideviramesh]

Which IIQ version are you inquiring about?

Version 8.3

Share all details related to your problem, including any error messages you may have received.

Using oracle direct database connector for database application integration .By default all the Dba_roles are having ADMIN option as NO. Need to have same roles with ADMIN Option=YES. Requirement is to have both option with and without ADMIN option for dba_role

[sreeram (Sreeram N)]

Hi @srideviramesh,

GRANT <RoleName> TO ${UserName} WITH ADMIN OPTION let me know if this works.

[srideviramesh]

Yes but am unable to aggregate the role into IIQ default role that gets added is with ADMINOPTION=NO in IIQ

[sreeram (Sreeram N)]

Could you please verify if you have given all the required permissions for aggregation

These are the permissions required:

Account Aggregation:

GRANT CREATE SESSION to <C##username> container=CURRENT;
GRANT SELECT ON dba_users TO ${UserName}; (By this command discovering schema is possible)
GRANT SELECT ON dba_sys_privs TO ${UserName};
GRANT SELECT ON dba_role_privs TO ${UserName};
SELECT * FROM V$PWFILE_USERS; (To view Sysdba privileges)
[For the CDB service account, the above permissions must be in the following format:]

GRANT SELECT ON dba_users TO <C##username> container=CURRENT;

For Group Aggregation:

GRANT SELECT ON dba_roles TO ${UserName}; (By this command discovering schema is possible)
GRANT SELECT ON dba_tab_privs TO ${UserName};
GRANT SELECT ON dba_col_privs TO ${UserName};
GRANT SELECT ON dba_sys_privs TO ${UserName};
GRANT SELECT ON system_privilege_map TO ${UserName};
GRANT SELECT ON V_$version TO ${UserName};
GRANT SELECT on V_$PWFILE_USERS to ${UserName};
GRANT SELECT ON dba_role_privs TO ${UserName};
SELECT * FROM V$PWFILE_USERS; (To view Sysdba privileges)

[For the CDB service account, the above permissions must be in the following format:]

GRANT SELECT ON dba_roles TO <C##username> container=CURRENT;