Hi folks,
I have a ... "challenge" that I'm trying to overcome. I am trying to design a report to run against the Seagate Info APS that will give me the directory structure and reports, with the groups and permissions. I have a report that will group by directory structure with the individual reports in the details. I have been in and out of the tables in the APS and while I see several potential linkages to get some form of user/group display, I haven't decoded any rights/permissions data. I have the Groups, Users, and a GroupUser table. I have RIIGHTROLES and SECRIGHTS tables, but I am stuck on decoding this. I ASSuME that I can go from the GROUPUSERS:Group_ID to the SECRIGHTS
RINCIPAL and that the resulting SECRIGHTS:SECRIGHT field will be a list of the rights for the group, but...
How do I tie the individual objects (Directories and reports) to either the ROLE or the GROUP so I can denote the permissions? Whew.
If I can just associate a ROLE w/ the object, that will _probably_ be enough... we only have a couple of entities that use the <USER_DEFINED> permissions -- against my preferences... the permissions just haven't been codified.
Any ideas?
Key words: APS, Seagate Info, Permissions, Roles, Groups, Reports
I have a ... "challenge" that I'm trying to overcome. I am trying to design a report to run against the Seagate Info APS that will give me the directory structure and reports, with the groups and permissions. I have a report that will group by directory structure with the individual reports in the details. I have been in and out of the tables in the APS and while I see several potential linkages to get some form of user/group display, I haven't decoded any rights/permissions data. I have the Groups, Users, and a GroupUser table. I have RIIGHTROLES and SECRIGHTS tables, but I am stuck on decoding this. I ASSuME that I can go from the GROUPUSERS:Group_ID to the SECRIGHTS
RINCIPAL and that the resulting SECRIGHTS:SECRIGHT field will be a list of the rights for the group, but...How do I tie the individual objects (Directories and reports) to either the ROLE or the GROUP so I can denote the permissions? Whew.
If I can just associate a ROLE w/ the object, that will _probably_ be enough... we only have a couple of entities that use the <USER_DEFINED> permissions -- against my preferences... the permissions just haven't been codified.
Any ideas?
Key words: APS, Seagate Info, Permissions, Roles, Groups, Reports