ACL's using SQL Backend

[Joseph D Wagner]

I don't want to use vfile as the acl backend.

I want to use sql, but it seems to be sparsely documented.  Would this work?

create table acls (

   acl_name varchar(255) not null,

   username varchar(320) not null default '',

   acl_value varchar not null,

   constraint acls_pk primary key (acl_name, username)

);

map {
   pattern = $key
   table = acls
   fields {
     acl_name = $key
   }
   username_field = username
   value_field = acl_value
}

Thanks.

Joseph D. Wagner