Re: how to allow User access to Tables

thanks, but it does not work;

    "select * from cat" results in an empty table     "select * from scott.cat" results in ORA-00942: table or view not existing

Rene Nyffenegger <rene.nyffenegger_at_gmx.ch> schrieb in im Newsbeitrag: slrncjreil.23g.rene.nyffenegger_at_zhnt60m34.netarchitects.com...
> In article <2q5nn9Frl94rU1_at_uni-berlin.de>, Mark wrote:
> > 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
>
> As Scott, do
>
> grant all on cat to TESTUSER;
>
> As TESTUSER, do
>
> select * from scott.cat;
>
>
> hth,
> Rene
>
> --
> Rene Nyffenegger
> http://www.adp-gmbh.ch/
Received on Tue Sep 07 2004 - 10:21:35 CDT