Profile parameters and their set limit - how to check?
Sankarmn
Community Edition User ✭✭
I have created the profiles.
How do I check by vsql to see what limits has been set for the created profile?
-5
Best Answer
-
Jim_Knicely - Select Field - Administrator
Check the V_CATALOG.PROFILES and V_CATALOG.PROFILE_PARAMETERS system tables.
Doc references:
https://www.vertica.com/docs/latest/HTML/Content/Authoring/SQLReferenceManual/SystemTables/CATALOG/PROFILES.htm
https://www.vertica.com/docs/latest/HTML/Content/Authoring/SQLReferenceManual/SystemTables/CATALOG/PROFILE_PARAMETERS.htm6