A relatively new feature, Proxy User Authentication allows you to connect using someone else’s credentials. Or as Oracle-Base puts it: Since Oracle 9i Release 2 it has been possible to create proxy users, allowing you to access a schema via a different username/password combination. This is done by using the GRANT CONNECT THROUGH clause on the destination user. So I’m …
How to Update the ORDS_PUBLIC_USER Password
ORDS_PUBLIC_USER is the database user that’s used to create your ORDS connection pool(s). Each database configured with ORDS gets one. When you publish a RESTful Service under HR on database X, ORDS resolves the call to the proper jdbc connection pool, then proxy connects from ORDS_PUBLIC_USER to user HR, and runs the SQL or PL/SQL. So, now imagine what happens …
Your #1 Reason for Upgrading SQL Developer to Version 4.2
Password resets. It used to be a pain – it required installing and configuring an Oracle client. But, no more! Simply get version 4.2, and you’re good to go. Here’s the video. So go get version 4.2 already.
Password Resets No Longer Require a Thick Connection (Oracle Client) in SQL Developer
Thanks to an update in a 12c JDBC driver for Oracle Database, we can now update a password natively, without being connected to the database. Previous to version 4.2 EA2 – users would either have to be connected already OR have an Oracle Client available. A post I did up explaining this is one of the most read articles on …
Migrating Oracle SQL Developer Connections (with Passwords!)
So you just got your brand new machine at work. Party time, excellent*! Amazon.com Widgets And, your friendly neighborhood IT guy even moved over all of your softwares, including SQL Developer. But when you go to use it, none of your connections are there. Or maybe the connections are there, but the connection passwords ARE not. And really, who has …
Oracle SQL Developer 4 and the Oracle Client
You don’t need to have an Oracle Client installed on your machine to use Oracle SQL Developer. Everything you need to connect to Oracle Database is provided by the JDBC driver included with the download. So you can be up and running in usually less than 5 minutes. But if you DO happen to have a Client on your machine, …
Resetting Your Oracle User Password with SQL Developer
STOP. DO NOT PASS GO – if you do not have version 4.2 of SQL Developer, I suggest going and getting it. It makes this 100% easier. You can see for yourself here. Or watch the movie. If you INSIST on staying on your older version of SQL Developer – please, continue on with the post! The OLD Instructions – …