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

[Chris Weiss]

but why would be it grey'd out in the first place?  did you change the setup 
option
to disallow ppl to grant access after he had already granted?

Dave Hall (address@hidden) wrote:
>
>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
>>
>