Here is the query to find the permission lists associated to a user:
SELECT A.OPRID, D.ROLEUSER, B.ROLENAME, B.CLASSID, C.ClASSDEFNDESC
FROM PSOPRDEFN A, PSROLECLASS B, PSCLASSDEFN C, PSROLEUSER D
WHERE A.OPRID=D.ROLEUSER AND B.CLASSID=C.CLASSID AND B.ROLENAME=D.ROLENAME AND A.OPRID= 'USER_NAME'
ORDER BY B.CLASSID
Subscribe to:
Post Comments (Atom)
OCI - Attach Block Volume to Windows VM
Tip: Although creating and attaching Block Storage to a Windows VM is pretty straightforward (OCI documentation is pretty good for that), th...
2 comments:
If we have a client who is multi-companies and each company have different standard hours, how can we achieve this since 1 user profile can only be tied to only 1 Primary permission list?
and as per the requirement we will have only one permission list
Please advice
No idea abt it... probably some reader may help on this. meanwhile, I'll try it at my end as well.
Post a Comment