on 04-25-2012 6:17 PM
Hi,
Quite new to HANA.
I have a table with just 2 fields on it (both STRING type) and just 1 record as content. I am now creating an attribute view on it, validates correctly but up on activation gives the following error:
MDXRuntime: Internal deployment of object failed: Internal Error:Deploy Attribute View: SQL: insufficient privilege:
Not authorizednCreate view DDL statement: CREATE COLUMN VIEW "_SYS_BIC"."abehanan/AB_ATTR_VIEW" TYPE JOIN WITH PARAMETERS
( joinIndex = "SYSTEM"."AB_TEST1", joinIndexType = 0, viewAttribute = ('FIELD1', "SYSTEM"."AB_TEST1", "FIELD1", '', 'default', 'attribute', '',
'abehanan/AB_ATTR_VIEW$FIELD1'), viewAttribute = ('FIELD2', "SYSTEM"."AB_TEST1", "FIELD2", '', 'default', 'attribute', '', 'abehanan/AB_ATTR_VIEW$FIELD2'),
view = ('V_AB_TEST1', "SYSTEM"."AB_TEST1"), defaultView = 'V_AB_TEST1', 'REGISTERVIEWFORAPCHECK' = '1' )nVersion: 42n
For the user (SYSTEM), I have added _SYS_BIC under SQL Priviliges and have given authority for everything from CREATE ANY to INDEX. The user also has all authorisations for the package (ABEHANAN) where I am creating the attribute view.
What could I be doing wrong?
Thanks in Advance,
Anooj
Thanks Rama & Manish for your responses.
Rama, I took your advice on board and used my user (who had CONTENT_ADMIN role) to create a table within my schema and then created a package with my user followed by an analytical view within it. However the activation still failed with the exact same error.
From experiencesaphana.com I got this SQL command:
grant select on schema <SCHEMA> to _SYS_REPO with grant option;
I gave SELECT access to _SYS_REPO to my schema and it worked. Now I am able to activate and re-deploy the model. The data preview which wasn't working before has also started working.
Thanks,
Anooj
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
This message was moderated.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Make sure you have granted select privileges for the schema where the raw tables are contained. You may also need to grant SQL privileges (select) for RS_REPLICATION_COMPONENTS.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Anooj:
Do not change any assignments to SYSTEM user unless you are absolutely sure on the change.
Please add to the user ID ABEHANAN the CONTENT_ADMIN role - log-off the user and try again using the same user ID.
Hope this helps.
Rama
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
25 | |
12 | |
9 | |
6 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.