Home » RDBMS Server » Security » creating a new user and grant issues
creating a new user and grant issues [message #73439] Thu, 29 April 2004 06:41 Go to next message
Messages: 99
Registered: March 2001

I had to create a new user  USERA to be used for doing updates on our oracle database via a web tool. So i created a new user apart from the current production user we have.

I then connected to the production user and gave

SQL> grant all on

When i connect to the database using the new user created USERA

>sqlplus usersa/pwd@dev


ORA-04043: object
does not exist.


Please help!

Re: creating a new user and grant issues [message #73457 is a reply to message #73439] Tue, 04 May 2004 22:45 Go to previous message
Prateek Sachan
Messages: 6
Registered: May 2004
Junior Member
Please give your new user CONNECT priviledge.

SQL> grant connect to usera;
Previous Topic: Problem in connecting as sysdba for manual database creation
Next Topic: Connectivity: SQL*Net and Security
Goto Forum:

Current Time: Tue Dec 06 08:52:59 CST 2022