Re: Read only user in oracle

From: Johnny Chan <j4ychan_at_PROBLEM_WITH_INEWS_GATEWAY_FILE>
Date: 1997/03/01
Message-ID: <5f7s4j$gl8@gw.PacBell.COM>#1/1

> Coulier Patrick (patrick_at_delight.be) 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 ???

> Sure create a role with select privileges on the tables concerned and then
> grant that role to all the users that you want to have "read only"
> permissions.

if you don't mind the user having read-only access to all tables, objects created by ANY user, there's an even easier way:

grant select any table to <user>;

Johnny Chan
Independent Oracle Specialist Received on Sat Mar 01 1997 - 00:00:00 CST