Bucket ACL import from Excel

[Former Member]

Hi all,

Can anyone explain to me how the import from excel to Buckets work when I want to change multiple users ACL (or actually I just want to delete the ACL for multiple users). In a bucket it is possible to add Multiple users and assign the same ACL for all of them, but when we need to change these it can only be done for one user at a time. I can't even remove the ACL for all users in one go.

So I was hoping that the import to bucket from Excel could help me here. I am unsure or what values to input when downloading the DX layout template. This template gives me four cells to fill:

1. External ID (I assume this is the bucket external ID

2. Activity (I assume this is the ACL meaning either ADMIN, WRITE, READ or NONE?????)

3. User (Here I assume this is username of the resource I want to change/delete the ACL)

4. Role ID (I assume this is the PFCG role if this was what I wanted to change ACL for?)

Any advice?

br,

Morten.

[former_member201206]

Hi Morten,

I think, you are right.

The ACL related records are stored in aco_user and aco_role accordingly. They are builded up straightforwarded :

object_id  guid of bucket  (in your case)

topnode_id guid of portfolio

, in you want to verify the input & output.

Kind regards,

Zhenbo