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!
|
|
Data from Seccodejoin table don't sync to remote
Posted: 07 May 08 11:18 AM
|
Hi
I need to know... why Seccodejoin table's data don' sync out to remote users database.
What Can I have to do to data pass to remotes ???
Please, Anyone can help me!!!!
Thanks in advance.
Patty |
|
|
|
Re: Data from Seccodejoin table don't sync to remote
Posted: 08 May 08 9:45 AM
|
Hi Patti,
I have an answer for you for remote servers, but unfortunately not for remote clients.
Our remote servers are on a WAN, so they can see each other. I created a dts package that connects to each of the remote servers and updates the seccodejoin table with the latest info. I then scheduled the DTS package as a job that runs every hour.
I don't know much about agents, but maybe there will be a way to use them to update remote clients.
Good luck
Ina |
|
|
|
Re: Data from Seccodejoin table don't sync to remote
Posted: 08 May 08 1:04 PM
|
Technically, and don't quote me on this, SECCODEJOINS only exists as a Many-to-Many membership table for the purpose of ensuring that the SECRIGHTS table stays in sync with SECPROFILE. There used to be a table called SECRIGHTSCACHE that had to be "rebuilt" any time a problem came up with people being able to see sutff they shouldn't - but the records in SECRIGHTSCACHE were actually in-memory tables stored as streamed objects in a BLOB field. It was a ropey setup, and you couldn't easily tell at any given time whether the data in the cache was correct.
Long story short, if you have a customization that depends on the existence of SECCODEJOINS on remotes, that's bad - the mechanism for manipulating security rights shouldn't exist on the remotes at all. Ideally you'd want to rewrite that customization to use SECRIGHTS instead. Obviously that can be manipulated too, but hey, one step at a time...? |
|
|
| |
| |
|
Re: Data from Seccodejoin table don't sync to remote
Posted: 08 May 08 3:56 PM
|
FYI - Seccodejoins is only used by the SalesLogix "admin" tool to maintain/display security (teams, etc) info. Nothing in the SalesLogix client (or other SalesLogix apps) uses it.. and in fact it's "internals" have changed (significantly) over time. Anyone using it should change to a method that does not reference it (like what Ryan described).
--
RJLedger - rjlSystems |
|
|
|