SAP Knowledge Base Article - Preview

3421101 - User <DB username> is missing valid privilege SELECT for <object type> SYS.<object name>

Symptom

With the HANA authorization trace profile set to Info (see 2370781), you notice exceptions similar to the following:

[343085]\{323500\}[148/-1] 2024-01-04 16:35:38.248641 i Authorization    SQLFacade.cpp(02710) : User <DB user name> is missing valid privilege SELECT for <object type>
SYS.<object name>

Alternatively, following Resolve Insufficient Privilege Errors to understand an insufficient privilege exception GUID, you see that your database user is missing the SELECT object privilege on a SYS schema object.

---

This KBA refers to SELECT authorization exceptions on SYS schema objects only.


Read more...

Environment

SAP HANA, platform edition

Product

SAP HANA, platform edition all versions

Keywords

KBA , HAN-DB-SEC , SAP HANA Security & User Management , Problem

About this page

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

Search for additional results

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