hana_sql
SQL - Les vues générées ayant des privilèges SQL non vide
select * from "_SYS_REPO" . "ACTIVE_OBJECT"
where object_suffix = 'calculationview'
and cdata like '%applyPrivilegeType="SQL_ANALYTIC_PRIVILEGE"%'
À partir de l’adresse <https://answers.sap.com/questions/12345830/system-table-for-view-privileges.html >
Moi pour affiner j'ai fait : (
select PACKAGE_ID , OBJECT_NAME from "_SYS_REPO" . "ACTIVE_OBJECT
where object_suffix = 'calculationview'
and cdata like '%applyPrivilegeType=" SQL_ANALYTIC_PRIVILEGE " % '
and OBJECT_NAME like ' Z % '
order by PACKAGE_ID
SYNTAXE OK:
set schema _SYS_REPO ;
select PACKAGE_ID , OBJECT_NAME , CDATA from "ACTIVE_OBJECT" WHERE "OBJECT_SUFFIX" = 'calculationview'
AND "CDATA" like '%PRIVILEGE%'
and "OBJECT_NAME" like 'Z%'
order by package_id
attention syntaxe pourri car manque des “”)