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

Analyze Schema Statistics — Vertica Forum

Analyze Schema Statistics

ersaurabhex

ersaurabhex - Select Field - ✭

December 2019 in General Discussion

https://www.vertica.com/blog/analyze-statistics-schema-level-part-2-quick-tip/
Based on above knowledge tips, I created a function but i have trouble giving access to individual database users. Only DBA user is able to run that.

Tagged:

0

Comments

Jim_Knicely

Jim_Knicely - Select Field - Administrator

December 2019 edited December 2019

Did you grant the EXECUTE privilege?

Example:

dbadmin=> CREATE USER joe;
CREATE USER

dbadmin=> GRANT EXECUTE ON PROCEDURE analyze_schema_statistics(schema_name VARCHAR) TO joe;
GRANT PRIVILEGE

dbadmin=> \c - joe
You are now connected as user "joe".

dbadmin=> SELECT analyze_schema_statistics('test_stats');
 analyze_schema_statistics
---------------------------
                         0
(1 row)

0

Leave a Comment