Adding/Changing Table Owner
827322Jan 7 2011 — edited Jan 12 2011I have recently added a new user schema to my workspace. I want to fully change over to this new user schema because I want to restrict all the access that APEX to just that user. The problem I am having is, I have changed the user schema for my application, but now all of my MRU functions and forms break because the Table owern is set to my new user schema and I don't have any other options.
How do I add not schemas to my workspace, but he other available schemas a schema can access? (Ugh, I'm totally new to the Oracle User = Schema thing, to a beginner it really doesn't make sense, is it just me??) Is this an Apex adjustment I need to make or a user schema privileges thing I need to change?
Thanks as always!!!