User wants to create a picklist with users having the ‘Read All’ privilege on a certain collection.

User wants to create a picklist with users having the ‘Read All’ privilege on a certain collection.

Replace '_collection_name_' with the collection name in question and run following script:

SELECT
g.name grantee_user,
decode(u.privilege_key,2,'Read', 3, 'Read/Write', 999, 'Full Control') privilege_assigned,
c.name collection_granted
from
eln_Collection_uses u,
eln_Collections c,
eln_collections t,
eln_collections g
where
u.collection_key=c.section_set_key
and u.grantee_key=g.section_set_key
and g.collection_type_key=t.section_set_key
and t.name='User'
and c.name= '_collection_name_';