Hi Brendan, This should fix the problem for new installs, however, I think there is still a bug in the farcry_core/packages/security/authorisation.cfc createPolicyGroup method. As it stands now you can not specify the policyGroupID when creating an new policy group with Oracle, which is what caused the policy group issue in the first place. (I'm not sure about postgreSQL.) My patch allows the policyGroupID to be specified for Oracle, however doing this can cause the dmPolicyGroup_seq to get out of sync with the dmPolicyGroup table, hence the dropping and adding of the sequence. I'm all for not having to do this, but I think the behavior of the createPolicyGroup method should be consistent across all supported databases.
--Nathan >-----Original Message----- >From: [EMAIL PROTECTED] >[mailto:[EMAIL PROTECTED] On Behalf >Of Brendan Sisson >Sent: Wednesday, June 16, 2004 2:06 AM >To: FarCry Developers >Subject: [farcry-dev] Re: Permissions and policy groups > >> Sorry for coming in late here guys but before I modify the codebase >> can the problem be fixed just by sorting out the >> permissionBarnacle.csv install file? For existing users we could add >> an update script to correct the problem. Dropping and re-creating >> sequences sounds like a bit of a workaround. > > >Three updated files in cvs. Please try a new install with the >updated files and see if that helps the problems with >postgreSQL and oracle. > >farcry_core/admin/install/_installFarcry.cfm >farcry_core/admin/install/dmSec_Files/permissionBarnacle.csv >farcry_core/admin/install/dmSec_Files/policyGroups.wddx > >-Brendan > --- You are currently subscribed to farcry-dev as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] Aussie Macromedia Developers: http://lists.daemon.com.au/
