Re: Synonym or Not Synonym

Vijay Banda wrote:
>
> Instead of creating synoynms, try using Roles, roles are very helpfull
>
> eg :-
>
> Create role my_test identifed by my_test;
>
> Grant which tables have, what kind of privs on each table..
>
> eg:-
>
> grant read, write on table_test_1 to my_test;
> grant read, wirte on table_test_2 to my_test;
> .....
> ...
>
> Finally grant the role the users, that you want
>
> grant my_test to user1;
> grant my_test to user2;
> .....
>
> Hope this helps
>
> Vijay K Banda

Sorry I missed the original question but it seems to me that you still need synonyms, otherwise everybody must refer to tables as "owner.table" rather than "table".

Ken Denny

-- 
                                __
 /|  /                       | /  \
/ | /   _        _           | \   |   _        _          _
  |<   / \    /|/ \         _|  \  |  / \    /|/ \      /|/ \      /\   |
  | \  \ /   / |   \       / |\  \ /  \ /   / |   \    / |   \    / |   |
  |  \__X___/  |    \___   \_/ \__X____X___/  |    \__/  |    \__/  \__/|
                                                                   _____|___
                                                                  /    /
                                                                 /____/