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!
|
|
Who can manage products
Posted: 17 Oct 06 9:24 AM
|
fiogf49gjkf0d How can I query the database to return a list of users that have the ability to manage products?  |
|
|
|
Re: Who can manage products
Posted: 18 Oct 06 9:23 AM
|
fiogf49gjkf0d I believe that the usersecfunctions table holds all the menu rights that are restricted for a given user. So if a userid is there, the option will be disabled. Here's what I came up with.
SELECT distinct ui.username FROM userinfo ui
LEFT JOIN usersecfunctions u ON u.userid = ui.userid AND functionname = 'ToolsManagerProducts'
WHERE u.userid IS NULL
Zeph |
|
|
| |
|