...
Code Block |
---|
set linesize 1000; set pagesize 1000; select 'revokePriv("' || gmlv.group_name || '", "' || gmlv.subject_id || '", AccessPrivilege.' || case when gmlv.LIST_NAME = 'admins' then 'ADMIN' when gmlv.LIST_NAME = 'readers' then 'READ' when gmlv.LIST_NAME = 'viewers' then 'VIEW' when gmlv.LIST_NAME = 'updaters' then 'UPDATE' when gmlv.LIST_NAME = 'optins' then 'OPTIN' when gmlv.LIST_NAME = 'optouts' then 'OPTOUT' else gmlv.LIST_NAME end || ');' as script from grouper_memberships_lw_v gmlv where subject_id = '12345678' and GMLV.LIST_TYPE = 'access' |
This oracle script will remove privileges on folders for a certain user:
Code Block |
---|
set linesize 1000;
set pagesize 1000;
select 'revokePriv("' || gs.name || '", "' || gm.subject_id || '", NamingPrivilege.' ||
case
when gf.NAME = 'stemmers' then 'STEM'
when gf.NAME = 'creators' then 'CREATE'
else gf.NAME
end || ');'
as script
from grouper_memberships_all_v gmav, grouper_fields gf, grouper_stems gs, grouper_members gm
where GMAV.FIELD_ID = GF.ID and gm.subject_id = '12345678' and GF.type = 'naming'
and GMAV.OWNER_STEM_ID = GS.ID and GMAV.MEMBER_ID = GM.ID
|
sdf