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

[Heiko Tobias]

Yes, that works fine - problem solved - thanks Dave!

Heiko

>
>> 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
>>
>