Re: access privileges

ericl_at_community.net wrote:
> 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

Create a ROLE and assign whatever prives you want on what tables, views, sequence numbers,.... and give the role to what ever user.

--
This posting represents the personal opinions of the author. It is not the
official opinion or policy of the author's employer. Warranty expired when you
opened this article and I will not be responsible for its contents or use.