PRIVILEGE_GRANTEES Dictionary table

[Private_Member_74512]

i can not execute view of effective_privilge_grantees just. only show me this message : sap DBTech JDB:[500] :predicates are required in a where clause : M_EFFECTIVE_PRIVILEGE_GRANTEES need predicates on columns ( connected by AND if more than one ) : an equal predicate on PRIVILEGE, an equal predicate on OBJECT_TYPE . how can i read this table ?

[pfefferf]

I think the message is already self-explanatory. There are security restrictions on that system view which does not allow a query w/o a restriction on the columns PRIVILEGE and OBJECT_TYPE. For both columns an equal predicate has to be defined in the where clause.

SELECT * FROM EFFECTIVE_PRIVILEGE_GRANTEES
WHERE PRIVILEGE = '<privilege>'
  AND OBJECT_TYPE = '<object_type>';

[Private_Member_74512]

hum... i want to see privilege of all user.