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
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 #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: Thu Mar 28 12:28:01 CDT 2024