Attribute View Error

[hardik_patel]

Hi Everyone,

I create an attribute view under hdbadm but when i activate it, I got the below error. Looks like my user is not authorized. How can i give the privilege to hdbadm?

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"."sflight/AT_AGENCY_DESCRIBED" TYPE JOIN WITH PARAMETERS ( joinIndex = "SFLIGHT"."STRAVELAG", joinIndexType = 0, viewAttribute = ('MANDT', "SFLIGHT"."STRAVELAG", "MANDT", '', 'default', 'attribute', '', 'sflight/AT_AGENCY_DESCRIBED$MANDT'), viewAttribute = ('NAME', "SFLIGHT"."STRAVELAG", "NAME", '', 'default', 'attribute', '', 'sflight/AT_AGENCY_DESCRIBED$NAME'), viewAttribute = ('CITY', "SFLIGHT"."STRAVELAG", "CITY", '', 'default', 'attribute', '', 'sflight/AT_AGENCY_DESCRIBED$CITY'), viewAttribute = ('COUNTRY', "SFLIGHT"."STRAVELAG", "COUNTRY", '', 'default', 'attribute', '', 'sflight/AT_AGENCY_DESCRIBED$COUNTRY'), viewAttribute = ('CURRENCY', "SFLIGHT"."STRAVELAG", "CURRENCY", '', 'default', 'attribute', '', 'sflight/AT_AGENCY_DESCRIBED$CURRENCY'), viewAttribute = ('AGENCYNUM', "SFLIGHT"."STRAVELAG", "AGENCYNUM", '', 'default', 'attribute', '', 'sflight/AT_AGENCY_DESCRIBED$AGENCYNUM'), constraint = ('SFLIGHT:STRAVELAG.MANDT', 0, '', "SFLIGHT"."STRAVELAG", "MANDT", 'eq', '$$client$$'), view = ('V_STRAVELAG', "SFLIGHT"."STRAVELAG"), defaultView = 'V_STRAVELAG', 'REGISTERVIEWFORAPCHECK' = '1' )nVersion: 42n

regards,

Hardik

[Former Member · Accepted solution]

Hi Hardik,

Does your user have _SYS_BI and _SYS_BIC schema added in 'SQL Privileges' with all permissions.

Basically you need atleast INSERT permissions in _SYS_BIC schema aded to your user as the activation creates a column view in this schema.

Regards,

Rahul

[Former Member · Accepted solution]

Hi Hardik,

Rahul is right, you need insert permission in _SYS_BIC schema.

On top of that you also need to give _SYS_REPO schema SELECT permission on your schema with this SQL:

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

I had a similar discussion thread few days ago: http://scn.sap.com/thread/3166966

Thanks,

Anooj