From: Daevid Vincent
Date: June 13 2003 4:07am
Subject: RE: Thousands of users?  Newbie question
List-Archive: http://lists.mysql.com/mysql/142607
Message-Id: <004a01c33161$54f09eb0$0401a8c0@dv>
MIME-Version: 1.0
Content-Type: text/plain;	charset="us-ascii"
Content-Transfer-Encoding: 7bit

Look into mod_auth_mysql -- this module rocks and I use it all the time.

> -----Original Message-----
> From: Curtis Maurand [mailto:curtis@stripped] 
> Sent: Thursday, June 12, 2003 3:33 PM
> To: 2Hosts.com
> Cc: mysql@stripped
> Subject: Re: Thousands of users? Newbie question
> 
> 
> 
> 
> I think that I would code it into my application.  
> Essentially, I would 
> set up Agents on your end so that your customer service folks 
> can set up 
> companies and administrative users for those companies.  Then let the 
> companies handle their own users.  Each company would have a database 
> password and a username/password combo to access their admin 
> section of 
> the website.
> 
> Curtis
> 
> On Wed, 11 Jun 2003, 2Hosts.com wrote:
> 
> > Hi Guys,
> > 
> > I intend my online database to be used by 100 or so 
> companies each with up
> > to 100 employees.  Each of these employees may add data as 
> required.  I
> > don't want to assign one password for an entire company, in case one
> > disgruntled ex-employee decides to post erroneous data.
> > 
> > So presumably I need to issue each employee a username and 
> password, then
> > remove this when the employee leaves the company (or grant 
> an admin for that
> > company permission to do it).
> > 
> > My questions are :
> > 
> > How is the username and password issue best handled when so 
> many potential
> > users are involved?
> > 
> > Should a username and password be added to the web form 
> used to add data?
> > or
> > Should I just use .htaccess to grant usernames and passwords so no
> > unauthorized user can access the submission form in the first place?
> > 
> > Which is less resource hungry?
> > 
> > 
> > 
> 
> -- 
> --
> Curtis Maurand
> mailto:curtis@stripped
> http://www.maurand.com
> 
> 
> 
> -- 
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    
> http://lists.mysql.com/mysql?> unsub=daevid@stripped
>