4/30/2024 11:30:36 PM
|
| |
| 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 SQL Server or Oracle database administration related to SalesLogix databases. View the code of conduct for posting guidelines.
|
|
|
|
User security issue when users are applied to certain teams
Posted: 08 Nov 06 2:44 PM
|
fiogf49gjkf0d SalesLogix v6.2 sp1 (We plan to upgrade to 7 when SP1 is released)
I am having a very strange internal database issue with user security, when a user is added as a member to certain teams. What happens is that all information on the Security and Calendar tabs of a users profile displays blank (lack of any values), when a user is applied to one of two teams. If I remove the user from the affected teams, the information in those two tabs shows up immediately. Add them back to the teams and it’s gone again. In addition, while the user is member of those two teams, if I try to update the Security or Calendar tabs, the information will not stick and often generates an executable exception error. The work around I have to use to update those security settings is to remove the user from the teams, update information as needed in those tabs, and add them back to the teams.
Now I called SalesLogix technical support about this issue and they suggested recreating the affected team. (At the time, this was only happening with a single team.) So I created a new team, reassigned the team members, realigned their accounts and activities, and updated the known plugin releases. Well after all that was done, the newly created team had the same issue and now another team has been affected.
I’ve been running SQL traces to try to identify what is being read and update, and I don’t see any obvious problems in the SecRight and SecJoins tables. Everything seems to link up correctly and trying different SecProfiles, doesn’t seem to make any difference.
So I was wondering if anyone has any insight or have seen anything like this before.
 |
|
|
|
Re: User security issue when users are applied to certain teams
Posted: 08 Nov 06 3:42 PM
|
fiogf49gjkf0d I would suggest upgrading service packs now, mainly for SLXProfiler.exe which was introduced in SP3 I believe. With it you can profile what SLX is doing aside from the core SQL. I doubt there'd be anything different than what SQL traces report, but there may be something that is happening at the provider level you're not seeing. I'd profile the user both as part of the infected team and standalone then compare the results. There should be a difference because if the SQL returns data, it should be present on screen but it's entirely possible that the SQL executes but it doesn't return data.
Also I believe this is in BLOB land. Just because the SQL matches up doesn't necessarily mean the BLOB contents are synchronized too. It's not too uncommon for BLOBs to corrupt, too. |
|
|
| |
|
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!
|
|
|
|
|
|
|
|