9/13/2025 9:33:44 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 installing SalesLogix and general installation topics. View the code of conduct for posting guidelines.
|
|
|
|
SalesLogix Secured Functions via a Bundle
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.. |
|
|
|
Re: SalesLogix Secured Functions via a Bundle
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. |
|
|
|
Re: SalesLogix Secured Functions via a Bundle
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'
|
|
|
|
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!
|
|
|
|
|
|
|
|