Issue with privileges

[Former Member]

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?

[former_member585404]

Hi,

Try This

grant select on schema SCHEMANAME to _SYS_REPO;

[former_member183326]

It is explained here

[Former Member]

HI Michael,

Thanks for your response.

I had gone through the wonderful blog of yours.

Question arises as for the schema privileges to _SYS_REPO and _SYS_BIC.

[lucas_oliveira]

Hi,

The Note does not ask to add _SYS_BIC to _SYS_REPO. I'm not sure why you're trying that.

Using a user with enough privileges (SYSTEM for example) you could grant SELECT on the schemas involved here.

Something like:

grant select on schema _SYS_REPO to SAPABC;

grant select on schema _SYS_BIC to SAPABC;

BRs,

Lucas de Oliveira

[Former Member]

Will it allow for _SYS_BIC.

Note does say about _SYS_REPO to SCHEMA and

_SYS_REPO <--> _SYS_BIC.

The screenshot says the same right.

[lucas_oliveira]

Hi,

The note says "You need grant the SELECT privilege on schema _SYS_REPO and _SYS_BIC to the database user". 

I'm not sure where you're stuck at now.

Have you granted the privileges? What's the current issue?

Regards,

Lucas de Oliveira

[former_member208449]

Hello

Have you tried this -

SCHEMA - SAPABC

Grant SELECT on SAPABC to SYS_REPO;