Skip to Content
0
Former Member
Aug 22, 2013 at 08:43 AM

other user access Attribute view

83 Views

When i log on HANA by user SYSTEM, created one Attribute view called ATV_DEMO1 in which source tables came from schema GW

Then created analyitic privilege called AP_DEMO1 related ATV_DEMO1

1. Create user ERIC

2. GRANT SELECT ON SCHEMA "ERIC" TO _SYS_REPO WITH GRANT OPTION;

3. Grant SELECT and EXCUTE privilege on schema _SYS_BIC to user ERIC

4. Grant SELECT and EXCUTE privilege on schema GW to user ERIC

5. Grant SELECT privilege on ATV_DEMO1 to user ERIC

6. Add AP_DEMO1 in Analytic Privilege to user ERIC

But when i log on by user ERIC and click data preview on ATV_DEMO1, then failed.

Error log is SAP DBTech JDBC: [257]: sql syntax error: Error:insufficient privilege: Not authorized at ptime/query/checker/query_check.cc:2137

How to solve this problem and looking forward your response???

Thanks a lot for everyone!