Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

alter a user password via a database link

660270Sep 17 2008 — edited Jun 24 2009
Hi,

I need to alter a users password in plsql to a remote database.
I have a db link setup but cannot see how to execute the Alter user command so it willl execute in the remote database.

I was hoping to do ALTER USER@dblink1 user IDENTIFIED BY newpasssword but Oracle does not like the @dblink in the alter command.

Does anyone know a way around this?

Thanks
This post has been answered by MichaelS on Sep 17 2008
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 22 2009
Added on Sep 17 2008
#oracle, #plsql, #sql
4 comments
6,443 views