Re: [Orchem-devel] Privileges for Oracle users - help

[<ma...@eb...>]

> Can anyone tell me how to change the user privileges for
>     everything required - views, procedures, Java, etc. I can do this as
>     SYS, but would prefer to do it all as a seperate user.
>     John
>

Hi John

you're supposed to let the "orchem" user account own the objects required,
not SYS. I hope that was clear from my documentation, if not let me know
how I might rephrase that.

So you can discard those objects owned by SYS (drop them, or just leave
them lying around)

Create a new account, say ORCHEM, if you don't have such an account yet.

With SYS, grant RESOURCE and CONNECT to ORCHEM.

This gives ORCHEM enough privileges to install the objects in its own
'schema' (schema means user realm in Oracle).
Then, as ORCHEM, create the tables, views and load the java.

Btw - as a start, you can instead start with setting up the unit test
environment. See documentation pages. This works from a CVS checkout, and
not only sets up Orchem in your database but also installs a little table
with a compound sample to test with.

good luck !
Mark