RE: Read Only User

From: Bobak, Mark <Mark.Bobak_at_il.proquest.com>
Date: Thu, 16 Dec 2004 15:25:49 -0500
Message-ID: <AA29A27627F842409E1D18FB19CDCF270195B7D1@AABO-EXCHANGE02.bos.il.pqe>

Juan,

Hmm....but Mladen could circumvent that by typing "commit" as soon as he logged in. ;-)

-Mark

Mark J. Bobak
Oracle DBA
ProQuest Company
Ann Arbor, MI

Hi I search some solution and found this , Maybe this trigger could help in some cases,=20 why don't you test.
:)
=20
CREATE TRIGGER FON.SADFASDF
AFTER=20
LOGON
ON DATABASE
..

WHEN USER=3D'MLADEN' THEN SET TRANSACTION READ ONLY;
..

/

--
http://www.freelists.org/webpage/oracle-l

Received on Thu Dec 16 2004 - 14:29:12 CST