Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Read only user in oracle
Coulier Patrick wrote:
>
> Hello there,
>
> I would like to know the minimum/easiest way to set up a "read only
> user" in oracle. This user should ONLY have "read only access" to ALL
> tables/objects created by another user.
>
> Any suggestions/hints ???
>
> Thanks in advance.
>
> Patrick
>
> --
> Patrick Coulier - Patrick_at_delight.be
> Delight Information Systems
> Oostende Belgium
Create a user and grant them the system privileges CREATE SESSION and
SELECT ANY TABLE. (Of course, this includes select on the data
dictionary tables as well, if security is a major issue.)
Received on Mon Mar 03 1997 - 00:00:00 CST