permissions for multi user mode

I am trying to create a new schema and would like to use normal user mode. I seem to be able to create the schema, but get an insufficient permissions access rights error when I try to import a file. The user is an admin on the database. What permissions does the account importing the file need? This is on Oracle 10g.

Derek

Import involves creation of new tables in the database, which is not permitted in single user mode.

The reason for this is to prevent multiple people trying to change things at the same time, or other such actions that would lead to bad things happening. For instance, consider what would happen if a table that was in use by other people was deleted.

For this reason things that modify the database structure, such as file import, must be done in single user mode.

Tim

Confusing, but Ok.

Is there a tutorial or how-to somewhere that walks through the process of setting up a central oracle db and then configuring Instant JChem for multiple users to read from the db? I am having great difficulty trying to find this information.

Derek

Are you refering to the oracle priviledges?

If so then the oracle privileges needed are described here:

http://www.chemaxon.com/instantjchem/ijc_latest/docs/admin/supported_dbs.html

(actually these are more than you actually need for oracle, but they will work).

When you first connect to the database from IJC you need to follow these instructions.

http://www.chemaxon.com/instantjchem/ijc_latest/docs/user/help/htmlfiles/connections/adding_schema.html

Once set up you connect to the IJC database as described here:

http://www.chemaxon.com/instantjchem/ijc_latest/docs/user/help/htmlfiles/connections/connect_to_schema.html

If you need to have a multi-user system (e.g. add multiple users each with their own IJC username and password) then you must set up security in IJC and specify permissions. Look here for details (and the links at the bottom of the page):

http://www.chemaxon.com/instantjchem/ijc_latest/docs/user/help/htmlfiles/security/about_security.html

Logging in to the database once the connection information is defined is described here:

http://www.chemaxon.com/instantjchem/ijc_latest/docs/user/help/htmlfiles/connections/logging_in.html

 

I hope this helps.

 

Tim

 

 

 

 

Tim,

It looks like I needed the 4th link. I ended up using the IJT database to store some user names for now. I will eventually go to active directory, but for our evaluation I think the IJC will be adequate.

Also, the second link appears to be broken for me.

Thank you and Szilard for your help.

Derek

The link is corrected.

Thanks

Tim