Comments

• 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