Skip to Content
0
Sep 10, 2013 at 04:46 PM

How to GRANT the Analytic Privilege _SYS_BI_CP_ALL using SQL?

3347 Views

I'm trying to define a user named LUMIRA that can be used as a least privileged user for accessing Analytic Views that I've created for use with Lumira.

So far, I did the following to define access to the various schemas

CREATE USER LUMIRA PASSWORD Hana1234;

GRANT SELECT ON SCHEMA "WIKIDATA" TO LUMIRA;

GRANT SELECT ON SCHEMA "_SYS_BI" TO LUMIRA;

GRANT SELECT ON SCHEMA "_SYS_BIC" TO LUMIRA;

GRANT EXECUTE ON "SYS"."REPOSITORY_REST" TO LUMIRA;

The problem is I can't figure out the syntax for granting the _SYS_BI_CP_ALL Analytic Privilege. I was able to do this in the UI as shown below.

This is what the privilege looks like in GRANTED_PRIVILEGES.

I'm using SPS5.

Thanks in advance,

Bill

Attachments

AV01.png (6.9 kB)
AV02.png (10.5 kB)