Re: how to allow User access to Tables

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/