Home » RDBMS Server » Security » creating a new user and grant issues
creating a new user and grant issues [message #61501] Thu, 29 April 2004 06:40 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 #61502 is a reply to message #61501] Thu, 29 April 2004 10:14 Go to previous message
Satish Shrikhande
Messages: 167
Registered: October 2001
Senior Member
try first with one table ....

grant select, insert, update, delete, references, alter, index on table_name to usera with grant option;
Previous Topic: New role object privileges
Next Topic: Problem in connecting as sysdba for manual database creation
Goto Forum:

Current Time: Sat Feb 04 09:53:46 CST 2023