cancel
Showing results for 
Search instead for 
Did you mean: 

_SYS_BIC: SAP DBTech JDBC: [258]: insufficient privilege: Not authorized

Former Member

Hi,

We run BW on HANA and i want to create a HANA model using BW tables.

I have tried to create a Calc. view and Analytical view using a DSO Table. I can validate and activate the model without a problem but i cannon see the Data preview. The following error is occured :

_SYS_REPO has all the privileges to access my Schema.

With the statement : SELECT * from "_SYS_BIC"."ehg-test/EHG_DSO_CALC" i don't have sufficient privileges.

When i create a Calc. view with a script i can see the Data:

  select  rt_asort, count(distinct rt_locatio)as filial
  from "SAPBW3"."/BIC/AAAAD_CLT00"
  group by  rt_asort
  ;

Has anyboby faced something like that? which privileges are required for this operation?

Thanks in advance,

Vjola Dule

Accepted Solutions (1)

Accepted Solutions (1)

Former Member

SAP Note 1761917 resolved this issues

Executing or activating an Analytic Object fails with "user is not authorized" or "invalidated view"

Resolution

1. Make sure _SYS_REPO has privilege SELECT WITH
GRANT OPTION for the schemas used. In order to grant _SYS_REPO this privilege
you can execute the following statement:

GRANT SELECT ON SCHEMA <YOUR_SCHEMA> TO _SYS_REPO WITH GRANT OPTION;

2. Make sure the user activating the Object has at
least SELECT privilege over the schemas used within the scenario. SQL
statement to grant this privilege would be:

GRANT SELECT ON SCHEMA <YOUR_SCHEMA> TO <USER_THAT_WILL_ACTIVATE_ANALYTIC_OBJECT>;

3. Make sure all the dependencies of the Analytic
Object to be activated is contained in the Analytic Privilege assigned to the
user that will actually activate the Main Analytic Object.

Former Member
0 Kudos

Hi.

Please help to me, Im using SYSTEM user to do access to HANA Database.

I follow your instruction:

1.- Select _SYS_REPO user

2.- Open SQL Privileges. The image show EHP5 Schema and Grantor EHP5

3.- The Schema have Select and  Grantable to Others

However when I execute the instruction

grant select on schema <SCHEMA> to _SYS_REPO with grant option;

The Log show this messagge

Could not execute 'grant select on schema EHP5 to _SYS_REPO with grant option' in 5 ms 571 µs . SAP DBTech JDBC: [258]: insufficient privilege: Not authorized

lbreddemann
Active Contributor
0 Kudos

virgilio avila wrote:

Hi.

Please help to me, Im using SYSTEM user to do access to HANA Database.

And that's were you are doing it all wrong!

SYSTEM is not meant to be used for accessing your system.

It's a bootstrap user.

Use it to setup your roles and privileges.

Setup admin users, assign the required permissions and then:

disable the logon for SYSTEM!

The problem here is: SYSTEM doesn't automatically get access to all schemas.

Why should it be that way?

Instead, to be able to grant a permission like "SELECT ON SCHEMA" the user account requires to have this permission itself including the GRANT OPTION.

So in your case the owner of schema EHP5 can grant a "SELECT ON SCHEMA" to the modelling user that you should be using.

- Lars

Former Member
0 Kudos

Than you Lars

I have created new system with EHP5 user and create new Attribute View whit EHP5 user.

The user EHP5 have SELECT permission on SCHEMA EHP5, however when I execute the attribute view the system send the same messaage.

In other hand the _SYS_REPO user, have  Permission on SCHEMA EHP5. However the mesaage it's the same.

Error: The model is not activated properly. BIMC tables contains no metadata of the model. Try re-deploying !!

https://mail-attachment.googleusercontent.com/attachment/u/0/?ui=2&ik=ab310942fb&view=att&th=13da882660cbdf41&attid=0.1&disp=inline&safe=1&zw&saduie=AG9B_P9eI3l7wPViqBK1Y95p-i-P&sadet=1364331803869&sads=MLXHA4WdFHKI8HpJMrNaaz2Gz-s

The attribute View is only a test for MARA tabla, when execute data preview only for one columns for example MATNET, the attribute preview WORKS , but if add a new column like a MTART, validate, activate and preview the attribute, the system send this message??

Error: The model is not activated properly. BIMC tables contains no metadata of the model. Try re-deploying !!

Thank you for your time.

Besta Regards

Former Member
0 Kudos

This message was moderated.

Answers (0)