I'm installing an application that provides a ".sql" script to create tables and other objects in a postgresql database. When I run the script as user "postgres" the script executes without errors. But then all the tables and other objects are owned by "postgres". A user that I created to access the tables, "newuser", doesn't have privileges needed to use them.
If I login as "newuser" and execute the install script, I get errors indicating "newuser" doesn't have privileges to CREATE FUNCTION's . How should I execute the install script so that all the objects are owned by "newuser" and the FUNCTIONS are created? What privileges does "newuser" need to create functions? I can't find that described in the postgres manual? thanks -- View this message in context: http://www.nabble.com/What-user-privileges-do-I-need-to-CREATE-FUNCTION%27s--tf4099063.html#a11656315 Sent from the PostgreSQL - admin mailing list archive at Nabble.com. ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org
