Manage Relational Connections
-- Assign permissions to relational connections for individual groups/owners SELECT 'assignpermission -o Connection -t Relational -n ',cnx.object_name, USR_GRP_PERM FROM opb_cnx cnx JOIN ( select ' -g "Informatica Administrators" -s SONIC_LDAP -p rwx' USR_GRP_PERM from dual union select ' -g "Informatica Developers" -s SONIC_LDAP -p rx' USR_GRP_PERM from dual union select ' -g "Informatica Operators" -s SONIC_LDAP -p rx' USR_GRP_PERM from dual union select ' -g Administrators -p rwx' USR_GRP_PERM from dual union select ' -g "Automated Runners" -p rx' USR_GRP_PERM from dual union select ' -u Administrator -p rwx' USR_GRP_PERM from dual union select ' -g Everyone -p ""' USR_GRP_PERM from dual union select ' -g Developers -p ""' USR_GRP_PERM from dual) USR_GRP on 1=1 ORDER BY cnx.object_name,USR_GRP_PERM -- Change owner of relational connections SELEC...