AWR with ora904 invalid identifier

[Former Member]

Hi all,

While trying to generate the AWR report, I obtained the error ora00904 - invalid identifier. While this can be solved by granting the permissions below...

grant select_catalog_role to ;

grant execute on dbms_workload_repository to ;

how do we check to which database user should this be granted to? Any way we can verify this?
Thanks.

[former_member184473 · Accepted solution]

Hello Castro,

You need to speficy the <sap-user>:

grant execute on dbms_workload_repository to <sap-user>;

you can check the <sap-user> with the following statement:

select owner from dba_tables where table_name = 'T000';

Check note 1078293 for further information:

Regards,

Eduardo Rezende

[former_member197466]

Hi  Castro,

You can check which user has assigned to this role using query.

select granted_role, grantee, default_role from dba_role_privs

where  granted_role='SELECT_CATALOG_ROLE';

Thanks,

Ivy