Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: grant access to new user
Maybe you just wanted to say
select <any_column(s)> from <scheme>.<table>
where scheme in most cases is equal to the DB user name of the owner of the
table???
Sybrand Bakker wrote:
> "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 - 15:23:50 CDT