| From: | km4hr <km4hr(at)netscape(dot)net> | 
|---|---|
| To: | pgsql-admin(at)postgresql(dot)org | 
| Subject: | What user privileges do I need to CREATE FUNCTION's? | 
| Date: | 2007-07-17 19:33:06 | 
| Message-ID: | 11656315.post@talk.nabble.com | 
| Views: | Whole Thread | Raw Message | Download mbox | Resend email | 
| Thread: | |
| Lists: | pgsql-admin | 
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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | De Leeuw Guy | 2007-07-17 20:21:26 | Re: cache problem (v2) | 
| Previous Message | Andrew Sullivan | 2007-07-17 19:21:56 | Re: cache problem (v2) |