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?
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.