Versions Compared


  • This line was added.
  • This line was removed.
  • Formatting was changed.


Code Block
[appadmin@lorenzo bin]$ ./ remove.script

Here is a more complicated example.  I want all groups in a certain folder which do not have an ADMIN privilege assigned to my application service principal, to assign that privilege.  Here is the query for oracle:

Code Block

select 'grantPriv("' || || '", "someid/", AccessPrivilege.ADMIN);' as script 
from grouper_groups gg where like school:apps:appName:spaces:%' 
and not exists
(select (1) from grouper_memberships_lw_v gmlv where = gmlv.group_name and list_name = 'admins' 
and gmlv.subject_id = 'someid/');



     (question) Questions or comments? (info) Contact us.