You're all probably sick of this now but I'm getting desparate... Summary: The user that Enterprise Manager *swears* is in the dbo role on the live server does not have permission to query tables that aren't qualified with the user name. As some parts of FarCry specify the user before the table and some don't, some areas (eg handpicked rule, some areas of user permissions, approving includes etc) no longer work. My dev server which mimics their setup pretty closely - same db username, even - does not have this problem.
What's happened now: 1) The sysadmin reowned all tables to a new user, removed the original user, then readded the original user, set the newly-added-original user to the dbo role, and then reowned all the tables back again. The end result was that the problem was not resolved, it's exactly like it was before. 2) To test, Kay decides to reown all tables on her working dev server as "dbo" rather than the original user which was in the dbo role. The test script, which attempts a straight cfquery without a fully qualified table name, now works. She then changes FarCry's database user in config\_serverSpecificVars.cfm to "dbo." and restarts IIS and CF for good measure. The result of this was that the (previously working) dev site appeared to be working for a short while. I decided to test deploying a custom rule to make sure that part was all still good and that the new tables would have the correct user. I went into Admin->COAPI Admin->Rule Class and got a big fat error message: Could not find the ColdFusion Component rules. The front end of the site now starts throwing errors about security so I reboot the server (it's a virtual machine and sometimes a bit flaky). Now I can't even go to the home page of the site without getting the "Could not find the ColdFusion Component rules" error (listed in full below). Help! Before I go and a) reown all the tables back to their original config b) sacrifice a chicken, does anyone have any ideas for salvaging the situation? -- Kay Smoljak http://kay.zombiecoder.com/ --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "farcry-dev" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/farcry-dev -~----------~----~----~----~------~----~------~--~---
