RE: Read Only User

Can't drop a connected user last time I checked, you need to kill
session, then drop, may require a DBMS_JOB call to accomplish, watch out
for the bug which causes jobs not to run, been hitting that one today on
some other things. We are getting into borderline virus writing here, I
am sure Pete can tell us a few easy ways to deliver the payload.
 
Thanks, fixing, I think this will work.

CREATE TRIGGER FON.SADFASDF
AFTER
LOGON
ON DATABASE
.
WHEN USER='MLADEN' THEN   
     REVOKE ALL ROLES FROM MADLEN;
     CREATE JOB 'DROP USER MLADEN';


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

Other related posts: