Home > Archive > PHP DB > July 2005 > Re: [PHP-DB] maximum allowlable length of any database account password
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Re: [PHP-DB] maximum allowlable length of any database account password
|
|
| Micah Stevens 2005-07-24, 8:21 pm |
|
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
| |
| Bastien Koert 2005-07-24, 8:21 pm |
| 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@raincross-tech.com>
>To: php-db@lists.php.net
>Subject: Re: [PHP-DB] 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:
>user
>string
>it
>it
>md5
>
>--
>PHP Database Mailing List (http://www.php.net/)
>To unsubscribe, visit: http://www.php.net/unsub.php
>
|
|
|
|
|