How to Inactivate the Oracle User?

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Praveen
    #1

    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
    Tags: None
    • LKBrwn_DBA
      #2
      Re: How to Inactivate the Oracle User?


      Try:

      ALTER USER THE_USER ACCOUNT LOCK;

      --
      Posted via http://dbforums.com

        Comment

        • Daniel Roy
          #3
          Re: How to Inactivate the Oracle User?

          "alter user ... account lock"

          Daniel

            Comment

            • Michael Kuznetsov
              #4
              Re: How to Inactivate the Oracle User?

              Hi Praveen,

              use this command:

              alter user <user nameaccount lock
              /

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



              spraveen2001@ya hoo.com (Praveen) wrote in message news:<98d8ec76. 0308130439.73ae 3fb1@posting.go ogle.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

                Comment

                • Irfan Bondre
                  #5
                  Re: How to Inactivate the Oracle User?

                  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@ya hoo.com (Praveen) wrote in message news:<98d8ec76. 0308130439.73ae 3fb1@posting.go ogle.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

                    Comment

                    • michael ngong
                      #6
                      Re: How to Inactivate the Oracle User?

                      spraveen2001@ya hoo.com (Praveen) wrote in message news:<98d8ec76. 0308130439.73ae 3fb1@posting.go ogle.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

                        Comment

                        • Praveen
                          #7
                          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@yahoo.co m (michael ngong) wrote in message news:<ecf365d5. 0308131156.5913 c170@posting.go ogle.com>...
                          spraveen2001@ya hoo.com (Praveen) wrote in message news:<98d8ec76. 0308130439.73ae 3fb1@posting.go ogle.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

                            Comment

                            Previous template Next
                            Working...