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 …
Oracle SQL Developer 101: The Very Basics
We spend a lot of time here talking about tips, tricks, and cool things that you might have missed. These posts generally all assume you’ve been around the Oracle Database block. But many of the folks that ultimately end up here, have NEVER touched an Oracle Database before. This post is for you. You have decided to use SQL Developer, …
30 SQL Developer Tips in 30 Days, Day 5: Connectivity Issues
The most frequently posted question when it comes to Oracle Database, HAS to be around connectivity. If you’re just starting out working with the database, not being able to connect to said database has to be a very frustrating experience. And for some reason our error messages tend to confuse folks even further. And not everyone has a DBA they …
Connecting to Oracle with SQL Developer using Bequeath
Bequeath is an interesting word. It’s hard to pronounce for starters, or at least it is for me. So if you want to trip me up during a seminar, ask me about how to connect to Oracle sans Listener. Then you’ll get to hear me try to say bi-ˈkwēth, -ˈkwēth, bē- from Merriam Webster Your database hasn’t died (at least …
Getting started with SQL Developer in less than 5 minutes
It’s easy to forget that many people still have not discovered SQL Developer, or are just getting started. Many of my recent posts have been on advanced topics, hidden tricks, and productivity tips. I want to spend some time in the next few weeks helping the beginners out there. I can’t think of a better place to start than with …
I Just Wanna Connect to Oracle!
I have had quite a few SQL Server folks tell me their first experience with Oracle (database) was a very bad one. It’s easy to understand why. Microsoft makes it very easy to connect to SQL Server from a Windows OS. If you have installed SQL Server on your machine, you also get a very nice and rich set of …