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!
|
|
Reading SalesLogix Security data
Posted: 30 May 07 2:07 PM
|
I want to be able to periodically scan user’s accounts to see who has access to various Menu features.
Currently I need to know who has access to menu item Tools-Maintenance-Replace Data.
I have not found a SalesLogix supplied feature to allow me to do this.
We have over 200 users. I REALLY don't want to have to look into each users account one by one.
Does anyone know of any tools or SQL script that will help me?
Thanks in advance.
|
|
|
|
Re: Reading SalesLogix Security data
Posted: 30 May 07 2:10 PM
|
I guess some info would be of help.
We are still using v 6.1.x on a SQL 2000 database.
We are in the planning phase of migrating to 7.2 on SQL 2005 so info for both configs. would be welcome.
|
|
|
|
Re: Reading SalesLogix Security data
Posted: 30 May 07 3:08 PM
|
This works with 6.2.6.1007. This SQL will display ENABLED users who do NOT have access to Tools - Maintenance - Replace Data.
SELECT
USERINFO."USERNAME",
USERSECFUNCTIONS."FUNCTIONNAME",
USERSECURITY."ENABLED"
FROM
(sysdba.USERINFO USERINFO INNER JOIN sysdba.USERSECFUNCTIONS USERSECFUNCTIONS ON
USERINFO."USERID" = USERSECFUNCTIONS."USERID")
INNER JOIN sysdba.USERSECURITY USERSECURITY ON
USERINFO."USERID" = USERSECURITY."USERID"
WHERE
USERSECFUNCTIONS."FUNCTIONNAME" = 'ToolsReplaceData' AND
USERSECURITY."ENABLED" = 'T'
ORDER BY
USERSECFUNCTIONS."FUNCTIONNAME" ASC,
USERINFO."USERNAME" ASC
|
|
|
|
Re: Reading SalesLogix Security data
Posted: 31 May 07 8:58 AM
|
Very cool David thanks , one question, when the enable is true then a user has access to this menu function correct?
Thanks again ML |
|
|
|
Re: Reading SalesLogix Security data
Posted: 31 May 07 9:04 AM
|
Basically if a user is active (logon enabled) and does not have access to the menu then they will display in the results of this query.
|
|
|
| |
|