[Top][All Lists]

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: [Phpgroupware-users] ACL-Problem in 0.9.14

From: Dave Hall
Subject: Re: [Phpgroupware-users] ACL-Problem in 0.9.14
Date: Tue, 09 Sep 2003 18:22:06 +1000

Heiko Tobias <address@hidden> wrote:

> Hi @All!
> Following problem in my 0.9.14 installation:
> I have groups assigned to my users. The acls are set by the groups.
> One user has allowed an other group to read and edit his 
> addressbook entries.
> Now he wants to disable this, but the checkboxes are unavailable 
> and checked.
> I have checked the admin-acls - nothing set.
> How can I solve/clean that?

You could try looking in phpgw_acl for the user in question.

This SQL should give you the value you need.

SELECT account_firstname, account_lastname, phpgw_acl.*  
FROM phpgw_accounts, phpgw_acl 
WHERE acl_account = account_id 
AND acl_appname =  'addressbook' 
AND acl_location !=  'run' 
AND account_lid =  'ProblemLogin';

Then simply use:
DELETE FROM acl_accounts
WHERE acl_appname = 'addressbook'
AND acl_location = '<LocationValueFromAbove>'
AND acl_account = '<AccountValueFromAbove>';

Make sure you you backup the db, just in case I am wrong.  Standard
disclaimer applies, I am happy to offered advice, but I will leave you
to use your own intelligence to totally stuff up your install ;)

Please let me know if this works.



> Thank you!
> Heiko
> _______________________________________________
> Phpgroupware-users mailing list
> address@hidden

Attachment: dave.hall.vcf
Description: Card for <>

reply via email to

[Prev in Thread] Current Thread [Next in Thread]