Обсуждение: Newbie question
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?
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
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?