Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: how to allow User access to Tables
hi Chuck,
I think I may have another problem and this is only the symptom, because I
already granted all and stil used schema name it does not work. I have
currently no idea what I could have forgotten.
"select * from cat" results in an empty table, like before
"select * from scott.cat" results in ORA-00942: table or view not
existing
I am going to be confused :-/
regards
Mark
Chuck <chuckh_nospam_at_softhome.net> schrieb in im Newsbeitrag:
Xns955D672981A0Echuckhnospamsofthome_at_130.133.1.4...
> "Mark" <Scollop027_at_gmx.net> wrote in news:2q5nn9Frl94rU1_at_uni-berlin.de:
>
> > hallo NG,
> >
> > I created a table under User SCOTT. If I make "select * from cat" I
> > see these table. fine. Now I created a new User TESTUSER and want him
> > to be able to access the table? How do I do this? I tried it with Toad
> > but did not find any menu to "connect" users and tables. I gave my
> > TESTUSER all grants SCOTT has, but this is not enough.
> >
> > Thanks and regards
> > Mark
>
> RTM
>
> In short, you need to grant permissions to the new user, and either
> prefix the table name with the schema name, or create a synonym if you
> want to access it without the schema name.
>
> --
> Chuck
> Remove "_nospam" to reply by email
Received on Tue Sep 07 2004 - 10:34:17 CDT