Re: Read only user in oracle

From: Joseph Testa <jtesta_at_freenet.columbus.oh.us>
Date: 1997/02/28
Message-ID: <5f6m25$g1s@login.freenet.columbus.oh.us>#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.

joe

-- 
Joseph S. Testa, Database Administrator, Ohio EPA
  N8XCT, Emergency Coordinator (EC) & Local Govt Liaison (LGL)
  Pickaway County, OH and Official Relay Station (ORS), message content
  are MY views and NOT my current employer.

Received on Fri Feb 28 1997 - 00:00:00 CST