From: Andrew Foster <afoster@educationalmeasures.com>
To: Ron Watkins <rwatki@gmail.com>
To: pgsql-admin@lists.postgresql.org
Subject: Re: Newbie question
Date: Tue, 20 Mar 2018 10:57:30 -0600
Message-ID: <ee6ccdda-b2d4-cad4-8209-be388d8efa4d@educationalmeasures.com> (raw)
In-Reply-To: <2a9a01d3c06b$8bb5d6a0$a32183e0$@gmail.com>
References: <2a9a01d3c06b$8bb5d6a0$a32183e0$@gmail.com>
Hi Ron,
If you GRANT CREATE and USAGE on schema FOO for the developer's user,
your developer should be able to create new objects (in this case,
functions) in schema FOO.
My suggestion for a best approach would be to consider what your default
privileges should be
(https://www.postgresql.org/docs/current/static/sql-alterdefaultprivileges.html)
as well as setting up groups so that you don't have to modify
permissions for each individual.
Hope this helps!
Andrew Foster | Educational Measures, LLC
Sr. Database Administrator
On 3/20/18 10:50 AM, Ron Watkins wrote:
>
> I am pretty new to Postgresql.
>
> I have a database with a schema, ill call it ‘FOO’ here in the message.
>
> I also have a developer, who want’s to create a function for use in
> the ‘FOO’ schema.
>
> Im not finding the appropriate command to allow that user to create a
> function in the FOO schema (or elsewhere).
>
> Is there such a command? I was looking under the ‘GRANT’ but I don’t
> see a way to grant “CREATE or REPLACE FUNCTION”.
>
> Am I missing anything here? What is the best approach?
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: afoster@educationalmeasures.com, rwatki@gmail.com, pgsql-admin@lists.postgresql.org
Subject: Re: Newbie question
In-Reply-To: <ee6ccdda-b2d4-cad4-8209-be388d8efa4d@educationalmeasures.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox