Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Syncing passwords across multiple databases
ronnie_yours_at_yahoo.com wrote:
> Its easy to write a procedure which can do this to a database where
the
> password management application resides. How does one go about
updating
> the user passwords in the remore database using stored procedure.
You could set up DB Links to access the tables on the other instances. In the stored procedure you use to update the table it can reference the other tables using the DB links.
See Creating Database Links in the Database Administrator's Guide: http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96521/ds_admin.htm#12904
If you don't have full time connectivity between the instances you could use Oracle Replication to copy the data from a main server to the remote servers.
See Advanced Replication:
http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96567/title.htm