Also, John,
Normally you would want to use three tables:
user table (with user_name and user_pass columns)
create table users
{
user_name VARCHAR(15) not null primary key,
user_pass VARCHAR(15) not null
};
roles table (with role_name column)
create table roles
{
role_name VARCHAR(15) not null primary key
};
user_roles (join table with user_name and role_name columns)
create table user_roles
{
user_name VARCHAR(15) not null,
role_name VARCHAR(15) not null,
primary key(user_name, role_name)
};
This is a well-worn wheel which I am not re-inventing.
Micael
At 02:11 PM 3/5/02 -0500, you wrote:
>Hello. I would like to be able to use a MySQL table for my user
>authentication instead of the unencryptable tomcat-users.xml. I have
>looked for this documentation, but have yet to find it. Anyone have
>ideas/knowledge they care to impart?
>
>John Hollingsworth
>
>
>--
>To unsubscribe: <mailto:[EMAIL PROTECTED]>
>For additional commands: <mailto:[EMAIL PROTECTED]>
>Troubles with the list: <mailto:[EMAIL PROTECTED]>
