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!
|
|
Question on Seccodeid
Posted: 30 Jun 10 9:56 AM
|
Not sure if this is the right section to place my question in....Any help would be more than appreciated...
A very basic question related to seccodeid
I have set a team 'Vendor Management' and this team has three people under it
A
B
C
I know the seccodeid of the team 'Vendor Management' which I can obtain from 'Seccode' table. But if I want to find out the people within the team using seccodeid which table/sql/join would i execute???? |
|
|
|
Re: Question on Seccodeid
Posted: 30 Jun 10 10:49 AM
|
SELECT SECCODEDESC, USERNAME
FROM USERINFO UI
INNER JOIN SECRIGHTS SR
ON SR.ACCESSID = UI.USERID
INNER JOIN SECODE SC
ON SR.SECCODEID=SC.SECCODEID
WHERE SC.SECCODEDESC LIKE 'Vendor Manage%'
|
|
|
|
Re: Question on Seccodeid
Posted: 01 Jul 10 11:08 AM
|
How to get a seccodeid from a userid?
Each person is associated with a seccodeid. Using Secright table it will give me multiple seccodeid based on the condition if the user is in a team or the team is placed within another department, etc... |
|
|
| |
|