Re: Change User

From: Joel R. Kallman <jkallman_at_us.oracle.com>
Date: Wed, 06 May 1998 11:35:37 GMT
Message-ID: <35504a5d.2677139@newshost.us.oracle.com>

On Tue, 5 May 1998 12:00:14 -0400, "Murtaza Doctor" <mdoctor_at_firstsense.com> wrote:

>
> Is there a way for a dba to change a login to another user
> - if he/she does not have the user password?
> (without logging off ofcourse).
>
> Sybase has the "setuser" command to do this.
>
> Thankyou.
>
>
>
>

Do this using the ALTER USER statement. If you are the DBA, you can change anyone's password without knowing what their old password was.

---

SQL> create user foo identified by foo;

User created.

SQL> grant connect, resource to foo;

Grant succeeded.

SQL> connect foo/foo;
Connected.
SQL> connect system/manager;
Connected.
SQL> alter user foo identified by newpassword;

User altered.

SQL> connect foo/newpassword;
Connected.
SQL>

---

Thanks!

Joel

Joel R. Kallman Oracle Government, Education, & Health

Columbus, OH                             http://govt.us.oracle.com

jkallman@us.oracle.com                   http://www.oracle.com

---

The statements and opinions expressed here are my own and do not necessarily represent those of Oracle Corporation. Received on Wed May 06 1998 - 06:35:37 CDT