Alter table with SET Column policy fails …

1

I found following issue :

  • when user is not owner of the table even if he has privilege to alter dremio fails returning an error about rights without further explanation.
    Changing the owner of the table is the workaround to be able to apply policy.

Dremio team do you confirm this behavior ? Do you consider it as a bug or expected (if so please update documentation by mentionning this prerequesite)

My case occurs in Rel 23.3 Dremio EE. Table is based on CSV files stored in NAS Source, schema is applied to folder.

2

@Arnie Depends if you are querying a PDS or VDS

  • If PDS you need select on the PDS
  • Querying a VDS i slightly different as when you login and run a query on the VDS, the query runs as the View owner. The login user needs SELECT on the VDS but the owner of the VDS needs select on the physical dataset that the vire refers to
3

I am querying a PDS and want to alter this PDS (TABLE). I am not authorized even if I have SELECT, ALTER grants … I can only alter this PDS with SET COLUMN POLICY if I am the owner of the PDS.
Note : my rights alter works for other changes but not to apply policies.

4

@Arnie That is the expected behavior, to add policies, either admin or owner of the table

5

Thanks - would you please update documentation ? It took me quite a long time to discover this behavior.