3 Replies Latest reply: Jan 28, 2013 6:52 PM by Vijayakumar Krishnapillai RSS

How to restrict users to all the views of a single package

Reza Ahoui
Currently Being Moderated

Hello

 

We have a requirement to restrict a user to do data preview for all the views (attribute, analytic and calculation) within one specific package. He should be able to do that for all the views in that package and there is no associated attributes restriction (hence no value restriction). We do not want the user to see views in other packages. We created an analytic privilege and chose all the views in that package, saved, activated and assigned it to our test user. However we still get authorization errors:

 

SAP DBTech JDBC: [256]: sql processing error: createMaterializedSearchResult failed error SQL: insufficient privilege: Not authorized

 

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

 

The above errors are fixed if we provide the user SELECT privilege over schema _SYS_BIC and _SYS_BI. However we do not want to provide him with access to those schemas as he would be able to get access to all run-time objects out of his package.

 

We would appreciate a solution

 

Thanks

 

Reza

Actions