Re: How to Inactivate the Oracle User?
From: michael ngong <mngong_at_yahoo.com>
Date: 13 Aug 2003 12:56:28 -0700
Message-ID: <ecf365d5.0308131156.5913c170_at_posting.google.com>
Date: 13 Aug 2003 12:56:28 -0700
Message-ID: <ecf365d5.0308131156.5913c170_at_posting.google.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
alter user mike account lock (Locks out the user)
alter user mike account unlock (opens up mike)
That should keep out a user
Michael Tubuo Ngong Received on Wed Aug 13 2003 - 21:56:28 CEST