Articles   Members Online:
-Article/Tip Search
-News Group Search over 21 Million news group articles.
-Delphi/Pascal
-CBuilder/C++
-C#Builder/C#
-JBuilder/Java
-Kylix
Member Area
-Home
-Account Center
-Top 10 NEW!!
-Submit Article/Tip
-Forums Upgraded!!
-My Articles
-Edit Information
-Login/Logout
-Become a Member
-Why sign up!
-Newsletter
-Chat Online!
-Indexes NEW!!
Employment
-Build your resume
-Find a job
-Post a job
-Resume Search
Contacts
-Contacts
-Feedbacks
-Link to us
-Privacy/Disclaimer
Embarcadero
Visit Embarcadero
Embarcadero Community
JEDI
Links
How InteBase stores the passwords? Turn on/off line numbers in source code. Switch to Orginial background IDE or DSP color Comment or reply to this aritlce/tip for discussion. Bookmark this article to my favorite article(s). Print this article
18-May-03
Category
Database Others
Language
Delphi 2.x
Views
138
User Rating
No Votes
# Votes
0
Replies
0
Publisher:
DSP, Administrator
Reference URL:
DKB
			 Author: Attila T.P.

How InteBase stores the passwords?

Answer:

InterBase stores all of it's user name information in a database called
ISC4.gdb. It is the "user" table that contains the "User_Name" and "Passwd"
fields for each user.To get a list of the valid user do a: select user_name
from users;

Just because a user is listed in the users table, doesn't mean that they have
rights to access any of the tables in InteBase. Access to each table is 
handled by sql grant and revokes and that data is stored in the actual 
database not isc4.gdb.

The passwords for each user is stored in the passwd field and are encrypted. 
The password is encrypted with the UNIX crypt routine (DES Salt). 
That routine requires a salt which is always "9z". The resulting encrypted
data is striped of the "9z" (11 char. left) and crypted again with the same
"9z" salt. The result, once striped of the "9z" is the encrypted password
as found in the ISC4.GDB database. 

			
Vote: How useful do you find this Article/Tip?
Bad Excellent
1 2 3 4 5 6 7 8 9 10

 

Advertisement
Share this page
Advertisement
Download from Google

Copyright © Mendozi Enterprises LLC