SAP Knowledge Base Article - Preview

2619013 - [Error] User is not authorized to use <object> because of missing grantable privileges on underlying objects

Symptom

Customer says user A created and activated a view 'V' under a schema 'S' based on a table 'T' (under Catalog Object).

Obviously, table 'T' is granted to user A.

Customer says he gave access to shcema 'S' with select and grantable yes to user B.

User B tried to access the view 'V' but getting following error messages:

[129932]{320596}[114/-1] 2018-02-09 23:36:41.543012 i Authorization SQLFacade.cpp(02528) : User A is not allowed to grant privilege SELECT for TABLE S.T

[129932]{320596}[114/-1] 2018-02-09 23:36:41.543040 i Authorization check_view.cc(01075) : User B is not authorized to use VIEW S.V because of missing grantable privileges on underlying objects


Read more...

Environment

HANA 1.0

HANA 2.0

Keywords

Authorization, privilege, not authorized , KBA , HAN-STD-DEV-MOD , SAP HANA Analytical Modeling , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.