permissions for multi user mode

User 369425e3ae

22-09-2009 00:02:16

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

ChemAxon fa971619eb

22-09-2009 12:35:10

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

User 369425e3ae

22-09-2009 15:44:18

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

ChemAxon fa971619eb

22-09-2009 21:12:16

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


 


 


 


 

User 369425e3ae

22-09-2009 21:55:10

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

ChemAxon fa971619eb

23-09-2009 03:50:28

The link is corrected.


Thanks


Tim