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 - General Administration
Forum to discuss general administration topics for SalesLogix (including LAN & remote topics). View the code of conduct for posting guidelines.

Forums RSS Feed

Back to Forum List | Back to General Administration | New Thread

View: Search:

Author

Thread: Retiring Users

Ian Fitzpatrick
Posts: 146

Retiring Users Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 27 Jun 07 3:24 PM

We are trying to retire users in v5.2 and the Workgroup Admin is telling us that the users are either the primary team member for a team or they still have accounts of contacts assigned to them. We know that the user is not the primary on any teams (or even on any teams for that matter) and we can't find any accounts, contacts, opportunities or activities owned by these users. What can we do now to free up a license? Is there any way to work around this?

I was thinking we might want to try writing a SQL statement to update the usersecurity table, but I'd rather get the retire user feature to work.

Thank you,
Ian

[Reply][Quote]

Frank Chaffin
Posts: 475

Re: Retiring Users Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 27 Jun 07 7:06 PM

Does anyone report to this user?
Did you Refresh the SecRights Cache for all users?

[Reply][Quote]

Bob (RJ)Ledger
Posts: 1103

Re: Retiring Users Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 27 Jun 07 9:31 PM

I see this happen all the time....

Go to Territory re-alignment and "test" by attempting to re-align accounts/contacts using the source (from) ownership of the user you are attempting to retire. Usually you will hit one.

--
rjl

[Reply][Quote]

Bob (RJ)Ledger
Posts: 1103

Re: Retiring Users Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 27 Jun 07 9:31 PM

[Reply][Quote]

Carla Tillman
Posts: 290

Re: Retiring Users Your last visit to this thread was on 1/1/1970 12:00:00 AM

Posted: 28 Jun 07 9:59 AM

Ian,

Double check in the SecRights table that there are not any 'old' records hanging around for your user. If any one has ever reported to this guy in the past, the old record will most likely still be there. Or if he has been removed from a team in the past You will need to remove any incorrect entries before moving on. If the table looks ok, your on your own! (grin)

Delete SecRights
Where accessid = 'myUser'
AND seccodeid = 'theIncorrectRecord'

Carla

[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 © 2025 Customer FX Corporation. The information and opinions expressed here are not endorsed by Sage Software.	code of conduct \|

page cache (param): 7/9/2025 10:46:14 AM