Skip to Content
0
Former Member
Aug 02, 2016 at 05:23 PM

Issue with privileges

94 Views

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?