471,050 Members | 1,331 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,050 software developers and data experts.

How to Inactivate the Oracle User?

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
Jul 19 '05 #1
6 8922

Try:

ALTER USER THE_USER ACCOUNT LOCK;

--
Posted via http://dbforums.com
Jul 19 '05 #2
"alter user ... account lock"

Daniel
Jul 19 '05 #3
Hi Praveen,

use this command:

alter user <user name> account lock
/

Regards,
Michael
Brainbench MVP for Oracle Programming
http://www.brainbench.com
sp**********@yahoo.com (Praveen) wrote in message news:<98**************************@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

Jul 19 '05 #4
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
sp**********@yahoo.com (Praveen) wrote in message news:<98**************************@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

Jul 19 '05 #5
sp**********@yahoo.com (Praveen) wrote in message news:<98**************************@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
Jul 19 '05 #6
Hi All,

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

alter user the_user lock/unlock;

Thanks,
Praveen

mn****@yahoo.com (michael ngong) wrote in message news:<ec**************************@posting.google. com>...
sp**********@yahoo.com (Praveen) wrote in message news:<98**************************@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

Jul 19 '05 #7

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by JWM | last post: by
1 post views Thread by Andrew Arace | last post: by
13 posts views Thread by Chris Botha | last post: by
2 posts views Thread by egoldthwait | last post: by
6 posts views Thread by Praveen | last post: by
1 post views Thread by DC_DBA | last post: by
reply views Thread by leo001 | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.