Hello,
I'm trying to limit a user to some sheets with the name starting with DT, I have several sheets in 2 different apps belonging in the same Stream.
To do it, i'm implementing at security level a new role "DT", only able to see object starting like "DT*" and I have also access to the stream
My user has the New role linked to his account and when looking at the preview, my user seems to be able to access the sheets, but when testing with the user, it does not work. My user can not even see the Finance stream.
The stream Finance has also his own security rule not associated with the user else the user is not limited to only the DT reports.
Any idea how i can enable only the specific sheets to mu user without touching the Finance stream security rule ?
