Thread: Permission to create a table in postgresql database
Hello All
I want to grant permission to user to create a table, alter table , create
sequence in postgresql database .
Please advice me
Thanks and Best Regards,
Ashok
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
On Fri, 2021-01-08 at 19:28 +0530, dbatoCloud Solution wrote: > I want to grant permission to user to create a table, alter table , create > sequence in postgresql database . Every user is always allowed to create tables and sequences, and every user can alter objects that it owns. To allow a user to create an object in a certain schema, give the user the CREATE privilege on the schema. Yours, Laurenz Albe -- +43-670-6056265 CYBERTEC PostgreSQL International GmbH Gröhrmühlgasse 26, A-2700 Wiener Neustadt Web: https://www.cybertec-postgresql.com