Re: How does one permit access tables to different users ?

In <42nt0d$pff_at_ddi2.digital.net> delphi <delphi_at_digital.net> writes:
>
>Swapan is right on but you can go one step further. Even though user
 A
>has granted access to user B on user A's table, user B must user both
 the
>schema and the tablename, i.e.
>
> select *
> from USER_A.EMPLOYEE;
>
>To eliminate the need to include the schema, create a public synonym
 and
>grant access via the public synonym
>
> CREATE PUBLIC SYNONYM EMPLOYEE FOR USER_A.EMPLOYE;
> GRANT ALL ON EMPLOYEE TO USER_B;
>

   You can either create a Private or a public synonym depending upon the requirement. My suggestion was based on the fact that user b only needs to see this table !!!

Swapan Jha Received on Thu Sep 07 1995 - 00:00:00 CEST