Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Create row policy on auto create table to hide deleted rows #85

Closed
subkanthi opened this issue Sep 14, 2022 · 2 comments
Closed

Create row policy on auto create table to hide deleted rows #85

subkanthi opened this issue Sep 14, 2022 · 2 comments
Labels
enhancement New feature or request

Comments

@subkanthi
Copy link
Collaborator

Create row policy on auto create table to hide deleted rows

@subkanthi subkanthi added the enhancement New feature or request label Sep 14, 2022
@subkanthi
Copy link
Collaborator Author

subkanthi commented Sep 14, 2022

CREATE [ROW] POLICY [IF NOT EXISTS | OR REPLACE] policy_name1 [ON CLUSTER cluster_name1] ON [db1.]table1
        [, policy_name2 [ON CLUSTER cluster_name2] ON [db2.]table2 ...]
    [FOR SELECT] USING condition
    [AS {PERMISSIVE | RESTRICTIVE}]
    [TO {role1 [, role2 ...] | ALL | ALL EXCEPT role1 [, role2 ...]}]

@aadant
Copy link
Collaborator

aadant commented Nov 8, 2023

No longer needed with the ReplacingMergeTree with is_deleted.

@aadant aadant closed this as completed Nov 8, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
enhancement New feature or request
Projects
None yet
Development

No branches or pull requests

2 participants