Skip to main content

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

  • November 9, 2016
  • 1 reply
  • 5 views

KKirkpatrick
Forum|alt.badge.img+1

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?

1 reply

Forum|alt.badge.img+2
  • Participating Frequently
  • November 9, 2016

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