Re: How to Inactivate the Oracle User?

Hi Praveen,

use this command:

alter user <user name> account lock
/

Regards,
Michael
Brainbench MVP for Oracle Programming
http://www.brainbench.com

spraveen2001_at_yahoo.com (Praveen) wrote in message news:<98d8ec76.0308130439.73ae3fb1_at_posting.google.com>...
> Hi All,
>
> I Created a Oracle user(schema) in my database. Now instead of droping
> the oracle user(schema), i want to inactivate it.
>
> Can anyone tell me how to inactivate the user instead of droping it?
>
> Thanks in Advance,
> Praveen
Received on Wed Aug 13 2003 - 19:00:09 CEST