2 Replies Latest reply: May 4, 2012 5:21 PM by ajallen RSS

    user password

    user3266490
      Hi,

      DB : 11
      OS : Aix 7

      We have situation to login into user schema.We don't know the password for that user.How to login into it?
      We unable to communicate to that user now.Application also running so we couldn't change the password?

      We want to rename a table and then create a new table then import it from dump.




      Thanks & Regards,
      VN

      Edited by: user3266490 on May 5, 2012 3:20 AM
        • 1. Re: user password
          ajallen
          Login as a user with ALTER ANY USER privileges, like sys.

          Grant proxy login, say to yourself.

          SQL> ALTER USER that_user GRANT CONNECT THROUGH user_me;

          Now you can use proxy login and you do not need that user's passwrd


          SQL> connect user_me[that_user]@mydatabase

          When prompted enter your password.

          You will be logged in as that_user.
          • 2. Re: user password
            ajallen
            You could also login as yourself with sufficient privileges.

            SQL> CREATE TABLE that_user.new_table AS SELECT * FROM that_user.old_table;
            or
            SQL> ALTER TABLE that_user.old_table RENAME TO new_table;


            You can do pretty much anything you want in another schema if you have sufficient privileges yourself. DBA role comes to mind, but be careful as it is all powerful.