Hello everyone,
Im having two permission issues on Dremio Cloud (next-gen projects) — I’d like to know if they’re expected behavior or bugs.
1) Privileges don’t cascade down the hierarchy. When I grant full privileges on the project to a user or role, they can browse the catalog and see the objects, but SELECT on a view fails. To make it work, I have to grant privileges on every folder in the path, one level at a time, down to the folder holding the VDS. With deeply nested structures this doesn’t scale. Shouldn’t privileges granted at the project level be inherited by the child folders and views?
its not following the inheritance explained in the docs:
2) GRANT OWNERSHIP on a UDF doesn’t change the owner. The statement completes successfully, with no error or warning, but the function still shows the original creator as its owner.
Has anyone run into either of these? Any confirmation or workaround would be appreciated.
Thanks!