The Forums on slxdeveloper.com are now retired. The forum archive will remain available for the time being. Thank you for your participation on slxdeveloper.com!
|
|
How to retrieve users and groups that have rights on a plugin?
Posted: 04 Sep 09 4:06 AM
|
Hi there,
I'm searching quite a while for informations on how to retrieve users and groups to whom a certain plugin was released. My goal is to create a functionality to gather plugin informations about form in order to display them especially for support purposes. So those "release informations" are very important for me to get 
Btw.: I'm currently on SLX6.2.6/SQL2000 but in the next few weeks we will migrate to SLX7.5.1/SQL2008  |
|
|
| |
|
Re: How to retrieve users and groups that have rights on a plugin?
Posted: 04 Sep 09 10:02 AM
|
There are a few additional things to keep in mind, for certain types of plugins, you would find many copies that are old development copies, and one copy that is the Source of the Releases.
From that copy you can get the released items, and from the UserID you could get the Users that have access to.
|
|
|
| |
| |
| |
|
Re: How to retrieve users and groups that have rights on a plugin?
Posted: 07 Sep 09 8:02 AM
|
And here is my initial stage for a solution:
SELECT
p.name, p.companyversion, p.userid,
s.seccodedesc, s.seccodetype
FROM
sysdba.plugin AS p
JOIN sysdba.seccode AS s ON (p.userid = s.seccodeid)
WHERE
name = 'TestScript' AND family = 'System'
Problem solved |
|
|
| |
|
Re: How to retrieve users and groups that have rights on a plugin?
Posted: 08 Sep 09 1:23 PM
|
But this relies on Family and Name to be unique descriptors, which they aren't.
For instance, you should always define a Type, as it is very likely to have a Mail Merge Template that matches the Name of a group, which would throw away your result.
Also, what about multiple "sourced" items. For example, 2 users create groups called "My Group" and then release it, how do you know which path you are dealing with?
So, you should always filter a single Type and then use the Based on to group items. The "original" items would have a NULL for the BASEDON as they are not linked to other plugins.
And then, if you are dealing with ADHOC groups you also have to take into account the DATACODE column (which should typically match the BASEDON value) as this is the value that is used to link the Group Items from the ADHOCGROUP table.
|
|
|
|