Re: how to allow User access to Tables

"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