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

[Dave Hall]

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.

Cheers

Dave

> 
> Thank you!
> Heiko
> 
> 
> 
> _______________________________________________
> Phpgroupware-users mailing list
> address@hidden
> http://mail.gnu.org/mailman/listinfo/phpgroupware-users
>

dave.hall.vcf
Description: Card for <dave.hall@mbox.com.au>