Re: maximum allowlable length of any database account password

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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


[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux