Re: How to Inactivate the Oracle User?

Hi All,

Thanks to everyone for the responses.
Yes, atlast i used the samething...

alter user the_user lock/unlock;

Thanks,
Praveen

mngong_at_yahoo.com (michael ngong) wrote in message news:<ecf365d5.0308131156.5913c170_at_posting.google.com>...
> spraveen2001_at_yahoo.com (Praveen) wrote in message news:<98d8ec76.0308130439.73ae3fb1@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 Thu Aug 14 2003 - 10:46:06 CEST