GRANT WITH INHERIT ??

From: Arbol One <ArbolOne(at)hotmail(dot)ca>
To: PostGreSQL MailingList <pgsql-general(at)postgresql(dot)org>
Subject: GRANT WITH INHERIT ??
Date: 2024-12-06 12:40:07
Message-ID: BYAPR12MB2808E99A12528CA6DD26D2A9BA312@BYAPR12MB2808.namprd12.prod.outlook.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello.

When enter this commands in psql :

*sudo -u postgres psql
CREATE GROUP arbolone_dev_group; // Create a group
CREATE ROLE company_admin LOGIN PASSWORD 'myPassword' CREATEDB IN GROUP
arbolone_dev_group CREATEROLE;
GRANT arbolone_dev_group TO company_admin WITH INHERIT TRUE;*

I get this error:
/ERROR:  syntax error at or near "INHERIT"
LINE 1: GRANT arbolone_dev_group TO company_admin WITH INHERIT TRUE;/*/
/*

Is there something I missed?

--
*/ArbolOne ™/*
Using Fire Fox and Thunderbird.
ArbolOne is composed of students and volunteers dedicated to providing
free services to charitable organizations.
ArbolOne's development on Java, PostgreSQL, HTML and Jakarta EE is in
progress [ í ]

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Arbol One 2024-12-06 12:53:44 Re: GRANT WITH INHERIT ??
Previous Message David G. Johnston 2024-12-06 05:06:42 Re: Errors when restoring backup created by pg_dumpall