Re: managing schemas

Thanks a lot.

I thought I tried the same thing, but I wasn't logged as the sales user when I tried the grant command.

thanks

Patrick

Kari Pannila wrote in message <391088D7.DC7B45D3_at_ougf.fi>...
>
>Hi
>
>You must grant some priviledges (select,delete,insert,update) to the
>second user.
>For instance:
>
>grant select on sales.myTable to user2;
>
>
>Kari
>
>(Mr.) Kari Pannila
> Oracle DBA
>
>
>--
>
>PS. Delete X from my mail address , it (X) is only for SPAMMERS.
> Poista X mail-osoitteen edestä, se on SPAMmereita varten.
>
>
>Patrick Joyal wrote:
>>
>> Hi,
>>
>> I've created two users, Production and Sales. Each users created their
 own
>> tables and procedures etc...
>>
>> But now I want the first user access the tables created by the second
 users.
>> I know I can create synonyms, but it don't seem to work. I can't even
>> access tables by using the schema, like
>>
>> select * from sales.myTable
>>
>> any help would be appreciated.
>>
>> thanks
>>
>> Patrick
Received on Wed May 03 2000 - 00:00:00 CDT