Re: Newbie question

Andrew Foster <afoster@xxxxxxxxxxxxxxxxxxxxxxx> · Tue, 20 Mar 2018 10:57:30 -0600



    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?