paul at nfg
Jan 13, 2009, 7:40 AM
Post #3 of 6
(390 views)
Permalink
|
Jon Duggan wrote:
>> I've been playing around with dbmail_acl and it doesn't seem to have
>> any
>> effect on my clients (tbird) abilities on the mailbox.
>>
>> I've created a test mailbox, then inserted my user_idnr and the mailbox
>> idnr, with all other values set to 0.. I'm still able to mark as read,
>> delete, insert etc etc.
>>
>> Am I missing an obvious setting somewhere?
>>
>> There doesn't appear much documention on this table.
>
> Checking through the source tarball, the only use of dbmail_acl is in migration and create table scripts... Is this table now redundant?
You're not looking right.
dbmail-2.2> grep -iE '(SELECT|UPDATE|INSERT).*acl' db.c
"SELECT * FROM %sacl "
"SELECT user_id, mailbox_id FROM %sacl "
"INSERT INTO %sacl (user_id, mailbox_id) "
"UPDATE %sacl SET %s = %i "
TRACE(TRACE_DEBUG, "Updated ACL for user [%llu], "
"SELECT %susers.userid FROM %susers, %sacl "
dbmail-2.3> grep -iE '(SELECT|UPDATE|INSERT).*acl' src/dm_db.c
r = db_query(c, "SELECT user_id, mailbox_id FROM %sacl WHERE user_id =
%llu AND mailbox_id = %llu",DBPFX, userid, mboxid);
return db_update("INSERT INTO %sacl (user_id, mailbox_id) VALUES (%llu,
%llu)",DBPFX, userid, mboxid);
return db_update("UPDATE %sacl SET %s = %i WHERE user_id = %llu AND
mailbox_id = %llu",DBPFX, right_flag, set, userid, mboxid);
return db_update("DELETE FROM %sacl WHERE user_id = %llu AND mailbox_id
= %llu",DBPFX, userid, mboxid);
r = db_query(c, "SELECT %susers.userid FROM %susers, %sacl "
--
________________________________________________________________
Paul Stevens paul at nfg.nl
NET FACILITIES GROUP GPG/PGP: 1024D/11F8CD31
The Netherlands________________________________http://www.nfg.nl
_______________________________________________
DBmail mailing list
DBmail[at]dbmail.org
https://mailman.fastxs.nl/mailman/listinfo/dbmail
|
