8/25/2025 9:30:38 AM
|
| |
| slxdeveloper.com Community Forums |
|
| |
|
|
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!
Forum to discuss writing script in Architect plugins for SalesLogix & general SalesLogix customization topics (for Windows client only). View the code of conduct for posting guidelines.
|
|
|
|
Easier way to set function security for multiple users in Admin...
Posted: 08 Sep 08 2:22 PM
|
Posted: 08 Sep 08 9:36 AM
Hi all I posted this in the administrator section, but I don't seem to get anywhere in there so I am posting this in here with some changes. I appologize for the double post.
I would have to assume being that there are many security tables in the SLX DB (SECFUNCTIONS, SECRIGHTS, Etc...) that it would be easier to change a function security for a given set of users by creating a simple script that would change values based in the right security tables.
For example, I want to create a simple SQL script that would remove the ability to see certain menu items (lookup accountmanager, etc..) for all our users without actually going into every single user in Admin and setting each option manually.
Any any clue on how to acheive this?
Thanks in advance, -RJ
|
|
|
|
Re: Easier way to set function security for multiple users in Admin...
Posted: 08 Sep 08 2:53 PM
|
| Ok, I see the usersecfunctions contains the data i need. If I enter a record with the function name I'm lookung for like: 'LookupAccountIndustry' I'm assuming this will take out that lookup for the user I specify. Here's one problem How do I write a script that can find all the users in the userinfo table (minus a few) and run a a statement and still have this sync out to all remotes? |
|
|
|
Re: Easier way to set function security for multiple users in Admin...
Posted: 08 Sep 08 3:43 PM
|
This script works on one record at a time. I'd like to be able to loop through the userinfo table and grab ID's to insert into this SQL withought having to do this in VBs.
insert into usersecfunctions (userid,functionname,modifydate,modifyuser,createdate,createuser)
values ('USERS_ID','LookupAccountIndustry',GetDate(),'ADMIN',GetDate(),'ADMIN') |
|
|
|
You can
subscribe to receive a daily forum digest in your
user profile. View the site code
of conduct for posting guidelines.
 Forum RSS Feed - Subscribe to the forum RSS feed to keep on top of the latest forum activity!
|
|
|
|
|
|
|
|