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