Home > Implement > Discussions

SAP HANA Resources

Discover solutions powered by SAP HANA that can fast track your implementation. Implement SAP HANA technologies for building the extraordinary.

1 Reply Latest reply: Aug 2, 2013 8:57 AM by Vishal Dhir RSS

Not able to access data without  _SYS_BI_CP_ALL Analytical privilage

Newbie
Currently Being Moderated

Hello,

 

I am creating a analytic privilege for new user. The analytic privilege is on a calculation view restricting region specific data.

 

I have provided below authorizations:

 

Role: Public

SQL privileges: _SYS_BI(Execute,Select), _SYS_BIC(Execute,Select), Repository_Rest(Sys) (Execute), CVG/CV_COPA(_SYS_BIC) (Select on calculation view)

Analytic privileges: CVS.CV_COPA

System privileges: CATALOG_READ, DATA_ADMIN

Package privileges: Repo.Read

 

when user tries to preview data with above privileges, below error is thrown:

 

Error: SAP DBTech JDBC: [2048]: column store error: search table error:  [2950] user is not authorized.

 

if Analytic privilege is changed to _SYS_BI_CP_ALL, user is able to preview the data but as expected the entire data set.

 

Is there something else i should be doing?

 

Thanks,

Vishal

More Like This

  • Retrieving data ...

Contact Us

SAP Experts are here to help.

Ask SAP HANA

Our website has a rich support section designed to help you get the highest quality answers quickly and easily. Please take a look at the options below to get you answers from the SAP experts.

If you have technical questions:

If you're looking for training materials or have training questions:

If you have certification questions:

Χ