Are you creating a table that manages user permissions or are you attempting
to interface with the db to set up proper user accounts for that partciular
db (like creating an account in the mysql db for new users?
Bastien
From: Micah Stevens <micah@xxxxxxxxxxxxxxxxxx>
To: php-db@xxxxxxxxxxxxx
Subject: Re: maximum allowlable length of any database account
password
Date: Fri, 22 Jul 2005 12:29:18 -0700
In MySQL you have to reload the database after account creation, is this
true
for Oracle/MSSQL as well?
-Micah
On Thursday 21 July 2005 8:53 am, babu wrote:
> Hi all,
>
> I am using php as UI for creating database accounts(oracle,mssql) to
> users.when the users enters his information like name, number etc i will
> generate a random string(password), and mail it to the user.I will also
> make md5(random string) and create an account for the database for the
user
> with md5 password. when the user tries to login he enters the random
string
> for password, i collect it and apply md5 and check the database account
> authentication. my problem is with the login check. i could see the user
> created in the database, but when he want to connect to the database ,
it
> does not connect. i have checked this entire process without using md5.
it
> worked excellently. i want to ask is it the problem of using md5, as it
> returns 32 bit strings. Does oracle or mssql accept 32 bit strings as
> passwords. the other thing is, is it a good idea to trim the obtained
md5
> string to some 10 bit for creating and checking the database account.
>
> Thanks
> babu.
>
>
>
> ---------------------------------
> Yahoo! Messenger NEW - crystal clear PC to PCcalling worldwide with
> voicemail
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
