2.1
List
folder details
SELECT SUBJ_NAME,SUBJ_DESC
FROM OPB_SUBJECT ORDER BY 1,2
2.2
List
of shared folders
SELECT SUBJ_NAME,SUBJ_DESC FROM OPB_SUBJECT
WHERE IS_SHARED <>0
ORDER BY 1,2
2.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
2.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
2.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
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.
You might comment on the order system of the blog. You should chat it's splendid. Your blog audit would swell up your visitors. I was very pleased to find this site.I wanted to thank you for this great read!! Gaming zone
ReplyDeleteThanks for the cool informative post. Keep up the great work :)
ReplyDeleteshare files
He said, "I want, not for personally for me, but for working Americans, to have a option, that if they don't like their health insurance, if it's too expensive, they can't afford it, if the government can cobble together a cheaper Insurance Policy that gives the same benefits, I see that as a plus for the folks." Here's that clip: Now, we all enjoyed O'Reilly's recent debate with Jon Stewart, complete with grinning compliments and O'Reilly's admitting he sometimes doesn't understand what Stewart is talking about. What Is Bluecross Insurance
ReplyDelete