Home » RDBMS Server » Security » I Need a help
I Need a help [message #142980] Tue, 18 October 2005 10:36 Go to next message
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
Re: I Need a help [message #143072 is a reply to message #142980] Wed, 19 October 2005 00:24 Go to previous messageGo to next message
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.
Re: I Need a help [message #143173 is a reply to message #143072] Wed, 19 October 2005 06:56 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
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.
Re: I Need a help [message #143190 is a reply to message #143173] Wed, 19 October 2005 07:24 Go to previous messageGo to next message
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.
Re: I Need a help [message #143283 is a reply to message #142980] Wed, 19 October 2005 14:34 Go to previous message
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.
Previous Topic: Column Masking for various levels of users
Next Topic: Restrict user from updating stored procedure
Goto Forum:
  


Current Time: Fri Mar 29 06:09:14 CDT 2024