Re: How to Inactivate the Oracle User?
From: Irfan Bondre <ibondre_at_yahoo.com>
Date: 13 Aug 2003 12:31:26 -0700
Message-ID: <8da2c1b2.0308131131.2d9277d3_at_posting.google.com>
Date: 13 Aug 2003 12:31:26 -0700
Message-ID: <8da2c1b2.0308131131.2d9277d3_at_posting.google.com>
You can revoke his create session priviledge, in that case he won't be able to login. Thus inactivated. But all his objects will still be available.
ibondre
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 - 21:31:26 CEST