pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  

help / color / mirror / Atom feed

From: Paul Förster <paul.foerster@gmail.com>
To: dbatoCloud Solution <dbatocloud17@gmail.com>
Cc: pgsql-admin <pgsql-admin@postgresql.org>
Subject: Re: Permission to create a table in postgresql database
Date: Fri, 8 Jan 2021 15:11:40 +0100
Message-ID: <A5C3DD1D-9A2B-41B3-B020-57C94FC9ECDD@gmail.com> (raw)
In-Reply-To: <CAEz7P_vRt1GcwHSeMi8uFmXgVf9EcxJ5jMDd0nLnHRUappJBQQ@mail.gmail.com>
References: <CAEz7P_vRt1GcwHSeMi8uFmXgVf9EcxJ5jMDd0nLnHRUappJBQQ@mail.gmail.com>

Hi Ashok,

> On 08. Jan, 2021, at 14:58, dbatoCloud Solution <dbatocloud17@gmail.com> wrote:
> 
> I want to grant permission to user to create a table, alter table , create 
> sequence in postgresql database .
> 
> Please advice me

see: https://www.postgresql.org/docs/current/sql-grant.html

I guess, the first syntax should be what you want.

Cheers,
Paul

view thread (3+ messages)  latest in thread

Message-ID: <A5C3DD1D-9A2B-41B3-B020-57C94FC9ECDD@gmail.com>
Permalink:  ../A5C3DD1D-9A2B-41B3-B020-57C94FC9ECDD@gmail.com/
Also on:    postgresql.org/message-id/A5C3DD1D-9A2B-41B3-B020-57C94FC9ECDD@gmail.com

copy link · copy postgr.es

reply

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: paul.foerster@gmail.com, dbatocloud17@gmail.com
  Subject: Re: Permission to create a table in postgresql database
  In-Reply-To: <A5C3DD1D-9A2B-41B3-B020-57C94FC9ECDD@gmail.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