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!

Administration Forums - Installation
Forum to discuss installing SalesLogix and general installation topics. View the code of conduct for posting guidelines.

Forums RSS Feed

Back to Forum List | Back to Installation | New Thread

View: Search:

Author

Thread: SalesLogix Secured Functions via a Bundle

Martin McRiley
Posts: 13

SalesLogix Secured Functions via a Bundle Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 01 Oct 07 5:08 AM

Does anyone know if it is possible to put Secured Functions in a Bundle?
Obviously it is possible to copy the record from the [SECFUNCTIONS] table,
however, I also need the entries in the [USERSECFUNCTIONS] table to be rebuilt, but I can't see a way of doing this.

Many thanks

Martin..

[Reply][Quote]

Rekha
Posts: 72

Re: SalesLogix Secured Functions via a Bundle Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 01 Oct 07 6:12 AM

How about creating SQL scripts and bundling it through architect ? If you happen to know any other idea, please let me know. I am also looking out for a better way to bundle secure function.

[Reply][Quote]

Martin McRiley
Posts: 13

Re: SalesLogix Secured Functions via a Bundle Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 01 Oct 07 9:05 AM

Used a bundled script in the end

INSERT INTO USERSECFUNCTIONS
SELECT u.userid as USERID, 'SecuredFunctionName' as FUNCTIONNAME, getdate() as MODIFYDATE, 'ADMIN' as MODIFYUSER, getdate() as CREATEDATE, 'ADMIN' as CREATEUSER
FROM userinfo u
INNER JOIN USERSECURITY us ON u.userid = us.userid
WHERE us.enabled like 'T' and u.userid not like 'ADMIN'

[Reply][Quote]

Page 1 of 1

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!

slxdeveloper.com is brought to you courtesy of Ryan Farley & Customer FX Corporation. This site, and all contents herein, are Copyright © 2024 Customer FX Corporation. The information and opinions expressed here are not endorsed by Sage Software.	code of conduct \|

page cache (param): 11/26/2024 7:48:09 AM