OraFAQ Forum: Security » I Need a help

Home » RDBMS Server » Security » I Need a help

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

I Need a help [message #142980]

Tue, 18 October 2005 10:36

nkemeno
Messages: 8
Registered: September 2005
Location: London

Junior Member

hi all'
p/s kindly help me with a trigger/code on how to validate a username and password in such a way that a user that is not in my database will not be able to logon.
thank Nkem

Report message to a moderator

Re: I Need a help [message #143072 is a reply to message #142980]

Wed, 19 October 2005 00:24

tarundua
Messages: 1080
Registered: June 2005
Location: India

Senior Member

nkemeno wrote on Tue, 18 October 2005 21:06

a trigger/code on how to validate a username and password in such a way that a user that is not in my database will not be able to logon.

Why do you want to write a trigger/code when this facility is provided by Oracle itself ? No one can log into Oracle unless one holds a valid username/password to log on.

Report message to a moderator

Re: I Need a help [message #143173 is a reply to message #143072]

Wed, 19 October 2005 06:56

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

Or may be the OP is looking into a custom authentication like storing the application users/passwords in the database.
A detailed information would be more useful.

Report message to a moderator

Re: I Need a help [message #143190 is a reply to message #143173]

Wed, 19 October 2005 07:24

nkemeno
Messages: 8
Registered: September 2005
Location: London

Junior Member

thank you very much, what i really want to do is to validate password field and username in such a way that it will logon only the people i have inserted already in my database
eg
create table logon(
user_name varchar2(20
password varchar2(6)
)
/
insert into logon values('Eugenia','falcon');
insert into logon values('Mark','mkert');
p/s i will be very happy if you help me out.

thank you.

Report message to a moderator

Re: I Need a help [message #143283 is a reply to message #142980]

Wed, 19 October 2005 14:34

bmahireddy
Messages: 14
Registered: March 2005

Junior Member

Password can be encrypted and stored in the table. Example of encrypting the password can be found here.

http://www.orafaq.com/scripts/plsql/password.txt

Connect to the database with a default userid/pwd and then try to crosscheck the entered userid/pwd with the one stored in the table. Make sure that the default userid/pwd has select only privileges on the user table.

Report message to a moderator

Previous Topic:	Column Masking for various levels of users
Next Topic:	Restrict user from updating stored procedure

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Oct 01 06:06:30 CDT 2025