RE: Read Only User

  • From: "Bobak, Mark" <Mark.Bobak@xxxxxxxxxxxxxxx>
  • To: <jreyes@xxxxxxxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
  • Date: Thu, 16 Dec 2004 15:25:49 -0500

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;
..
/
--
//www.freelists.org/webpage/oracle-l

Other related posts: