Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by CatherineDevlin

  1. CatherineDevlin

    link oracle table from access database

    Accessing the database through an ODBC datasource should, from the database's point of view, be identical to accessing it through a SQL*Plus window. Can you open a SQL*Plus window with the same username/password@instance as the datasource and verify that they appear in ALL_TABLES?
  2. CatherineDevlin

    validate a password within PL/SQL?

    Wow! Musafa, I am amazed! Thank you! Belive it or not, I had actually thought about this technique, too. But apparently I did something wrong on my own attempt, and because the approach seemed far-fetched, I lost courage when I got error messages and figured it was just too weird to work...
  3. CatherineDevlin

    validate a password within PL/SQL?

    Hi! I'm looking for a way to validate a password within PL/SQL. I want to write CREATE PROCEDURE change_password(old_password IN VARCHAR2) IS BEGIN -- check if old_password is correct... but how? I can get the hashed value of the password from DBA_USERS, of course, but is there a way to...

Part and Inventory Search

Back
Top