We're Moving!

The Vertica Forum is moving to a new OpenText Analytics Database (Vertica) Community.

Join us there to post discussion topics, learn about

product releases, share tips, access the blog, and much more.

Create My New Community Account Now


Is it possible to restrict/limit the amount of disk space (or licenced space) of indivual users — Vertica Forum

Is it possible to restrict/limit the amount of disk space (or licenced space) of indivual users

Now and then a novice user mistakenly runs a CTAS that fetches far more data than intended.

CREATE TABLE T AS SELECT * FROM MASSIVE_TABLE;

 

Is there a user setting, resource pool setting, or schema setting that can be used to restrict the amount of disk space an individual user might consume?

Comments

  • No, it is not possible. There is a feature request similar to this but it is not on the roadmap. I will add your interest so PM can prioritize it. 

     

    Eugenia

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file