Re: access privileges

In article <DDvDrM.H1L_at_utnetw.utoledo.edu>,

   krajan_at_uoft02.utoledo.edu (krishna rajan) wrote:
>Hi ,
> I am new to the world of oracle.I have a question on oracle userid.
>I am working on a project and have created all my tables under one userid
>(userid1/passwd1) for the project. I want to give read-only access to some
>of the other people who are working with me on the project. I am using
>MS-access as a front-end.I created another oracle userid(userid2/passwd2)
>and granted select on all the tables on userid1 to userid2. Now all the
>people are able to look at the table on MS-access. But under userid2 on
>oracle there are no tables.I understand why , because i gave only select
>privilege to userid2. My question is , how do i show all the tables under
>userid2 so that they are still read-only on oracle ?.
>Thanks in advance.
>Krishna

If I understand your problem correctly, you can create synonyms in userid2's schema

Logging in as user2

create synonym table1 for userid1.table1

This will allow userid2 to see the same table as userid1.

I hope that this is what you're looking for.

Good luck,

Eric Received on Sat Aug 26 1995 - 00:00:00 CEST