![oracle 10g poster oracle 10g poster](http://www.britishpictures.com/photos3/pics/oracle_poster.jpg)
Now in this very specific case, the poster wanted a way to create a private database link without knowing the password of the user and without changing it as clients use this user. Now this is useless for this purpose (but database link).
![oracle 10g poster oracle 10g poster](https://i.gr-assets.com/images/S/compressed.photo.goodreads.com/books/1506671895l/36323018._SX318_.jpg)
I said that su.sql was first created to make easier DBA work when they have to grant privileges on objects and this was only possible by object owner. Here are some points I want to clarify if you have some time to waste. I am the "fellow moderator" Barbara was talking about (although I'm more an agitator).
![oracle 10g poster oracle 10g poster](https://oraclework2.files.wordpress.com/2014/04/oracle_10g_-backup-and-recovery-poster.png)
So, I would appreciate it if you would please share your current thoughts on this topic.
ORACLE 10G POSTER UPDATE
However, it was pointed out by my fellow moderator that, as the years go by, and things change from version to version, your point of view sometimes changes and you may not remove or update old threads. My initial thinking was that if you thought it was appropriate to provide the script publicly on your website, then that was good enough for me. A fellow moderator expressed concern that this might not be appropriate for current versions and that by supplying your script, I might be providing someone with a method for hacking or some such illegitimate purpose. In response, I supplied a link to your script. Recently, somebody on the OraFAQ forums, who said he had sys privileges, asked for a way to connect as another user, in order to create a private database link to a remote database, without having to ask the user for his password or permanently change the user's password, which would affect other things, or supply the remote password to the user. Do you still consider your su.sql script for connecting as another user, that you gave in this thread, at the link appropriate for currently supported Oracle versions (9i, 10g, 11g) or is there a better way now? I see that this is a very old thread and was wondering if it still applies.