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
Arpit
Messages: 99
Registered: March 2001
Member
Hi:

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
to USERA

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

>sqlplus usersa/pwd@dev

SQL>desc

ORA-04043: object
does not exist.

 

Please help!

Thanks,
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 Mar 19 02:06:53 CDT 2024