Re: grant access to new user

"Thomas Vatter" <thomas.vatter_at_blinx.de> wrote in message news:Xns909B9C350FD6Cthomasvatter_at_192.168.115.1...
> I have created a database as 'system' and try to give access for other
> users. I created a new user with 'create user identified by passwd' and
> made 'grant connect to user' and 'grant select, insert, update to table'.
> But after that the new user can't select the tables, error is 942, Table
> or view not found. Same in sqlplus as with jdbc.

First of all, *NEVER EVER* create tables under the user SYSTEM. Secondly: this is the expected behavior if you only granted access, but didn't create either a private or a public synonyms. This basic question and your previous questions are documented in Oracle manuals. Could you *please *
at least *try* to consult them, so you don't need to come up with these basic questions?
Oracle is not Informix, is not MySql, is not Sybase, it's not Sqlserver. You can't master Oracle by just hacking away.

Regards,
Sybrand Bakker, Oracle DBA Received on Tue May 08 2001 - 09:02:09 CDT