Setting user group privileges

Hi,
Anyone know is it possible to set a user group for access to a mysql
database and just this user group? Eg.
Name: Joe Password: happy
Name: John Password: sad.
Also using perl interface.
The reason I want is this is for a log in screen idea.


************************************************************ **********
This document is strictly confidential and is intended for use by
the addressee unless otherwise indicated.
Allied Irish Banks
************************************************************ **********


--
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe: http://lists.mysql.com/perl?unsub=gcdmp-msql-mysql-modules@m .gmane.org