Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> How can i lock an user from a package?

How can i lock an user from a package?

From: Alvaro G?lvez <bakanon_at_yahoo.com>
Date: 30 Nov 2004 11:59:04 -0800
Message-ID: <dce856b.0411301159.7bddae42@posting.google.com>


Hi
 I need to lock an oracle user from inside a package, so i can't use ALTER instruction... If i do

ALTER USER username ACCOUNT LOCK;

it throws the following:

PLS-00103: Encountered the symbol "ALTER" when expecting one of the following:

   begin declare exit for goto if loop mod null pragma raise    return select update while Received on Tue Nov 30 2004 - 13:59:04 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US