5.1 List folder details
SELECT SUBJ_NAME,SUBJ_DESC FROM OPB_SUBJECT ORDER BY 1,2
5..2List of shared folders
SELECT SUBJ_NAME,SUBJ_DESC FROM OPB_SUBJECT
WHERE IS_SHARED <>0
ORDER BY 1,2
5.3 List of Users and groups having privileges’ on Folders
SELECT(select repository_name from OPB_REPOSIT_INFO) repo_name,subj.subj_name folder_name, user_group.NAME user_name,
DECODE (obj_access.user_type, 1, 'USER', 2, 'GROUP') TYPE,
CASE WHEN ((obj_access.permissions - (obj_access.user_id + 1)) IN (8, 16))THEN 'READ'
WHEN ((obj_access.permissions - (obj_access.user_id + 1)) IN (10, 20))THEN 'READ EXECUTE'
WHEN ((obj_access.permissions - (obj_access.user_id + 1)) IN (12, 24))THEN 'READ WRITE'
WHEN ((obj_access.permissions - (obj_access.user_id + 1)) IN (14, 28))THEN 'READ, WRITE EXECUTE'
ELSE 'NO PERMISSIONS'
END permissions
FROM opb_object_access obj_access,opb_subject subj,opb_user_group user_group
WHERE obj_access.object_type = 29
AND obj_access.object_id = subj.subj_id
AND obj_access.user_id = user_group.ID
AND obj_access.user_type = user_group.TYPE
-- and user_group.NAME not in
('Admin','READ_ONLY','Administrator','Administrators')
order by 1,2,3
5.4 List of Folder Owners
select (select repository_name from OPB_REPOSIT_INFO) repo_name,
a.SUBJ_NAME,b.NAME
from opb_subject a, opb_user_group b
where a.owner_id = b.id
order by 1,2
5.5 Drop list of folders using Script
pmrep
connect -d Domain_NAME -n USERNAME -x PASSWORD -r RS_NAME
while read p; do
echo $p
echo "DELETING" $p
pmrep deletefolder -n $p
done < Filewithlistoffolderstobedeleted.txt
Step
1 : Enter the folder names in a file Filewithlistoffolderstobedeleted.txt
Step 2: Enter the details to connect to repository in pmrepconnect command
Then
execute the script.
Let
me know if this helps or if you need some other info for the same.