Hi team,
I have a question was checking the SAP note.
1897236 - HANA: Error "insufficient privilege: Not authorized" in SM21
For the query.
SELECT GRANTEE, GRANTOR, OBJECT_TYPE, SCHEMA_NAME, PRIVILEGE, IS_GRANTABLE, IS_VALID
FROM SYS.GRANTED_PRIVILEGES WHERE GRANTEE = 'database user'
For the schema SAPABC how can i grant access to _SYS_REPO and _SYS_BIC.
grant select on schema _SYS_REPO to SAPABC
grant select on schema _SYS_BIC to _SYS_REPO
How can this be achieved?