Content-Type: multipart/alternative;
 boundary="------------bHpvl3AGp9AEy0zsv0fNadq0"
Message-ID:
 <BYAPR12MB2808635594F3C83188FA5862BA312@BYAPR12MB2808.namprd12.prod.outlook.com>
Date: Fri, 6 Dec 2024 07:53:44 -0500
User-Agent: Mozilla Thunderbird
Subject: Re: GRANT WITH INHERIT ??
To: pgsql-general@lists.postgresql.org
References: <BYAPR12MB2808E99A12528CA6DD26D2A9BA312@BYAPR12MB2808.namprd12.prod.outlook.com>
Content-Language: es-ES, en-CA
From: Arbol One <ArbolOne@hotmail.ca>
Organization: ArbolOne
In-Reply-To: <BYAPR12MB2808E99A12528CA6DD26D2A9BA312@BYAPR12MB2808.namprd12.prod.outlook.com>
MIME-Version: 1.0
X-MS-Exchange-MessageSentRepresentingType: 1
X-MS-PublicTrafficType: Email
X-MS-TrafficTypeDiagnostic: BYAPR12MB2808:EE_|DM4PR12MB7525:EE_
X-MS-Office365-Filtering-Correlation-Id: 9cfffd8b-ac40-4ee0-26a9-08dd15f505e9
X-Microsoft-Antispam:
	BCL:0;ARA:14566002|19110799003|5072599009|7092599003|461199028|8060799006|15080799006|3412199025|440099028;
X-Microsoft-Antispam-Message-Info:
	=?utf-8?B?NXBINTAvNVlGNUc3aEJvYlVWYlZpMnZ1bzA0bmQrY2t4dHFYbVF2cW1raVZD?=
 =?utf-8?B?OHd3M1AzY1NJbVR4RkY4U0dFczVBT1RyZ1R3Zkc3bDVoTElwTUlpTjEvbFlX?=
 =?utf-8?B?LzU4SVpKZmYvM29VanZrbnViS0ZhY1VhL0xKcDY1SWxEeU1LQ2lSOGJNQmNH?=
 =?utf-8?B?bXh3YlJxbklSUk9UbDRmUjdKeUkzOWFLSzBrUU1zYjVkT0xFdHFCaHE1N0Jh?=
 =?utf-8?B?NS9hYjFtMDN1bk9RcXFXbnFFYTlsdGl3azVJNndOZ0pzVkFuaUMrR0ZIZ01i?=
 =?utf-8?B?a3hBbmMxbFFGNUZEZnNyd0Zqd3V2VUhobGNqNTV2RGtNS2xlVWNoZXpxQXhU?=
 =?utf-8?B?alR2YWV4djBJcEcydUJwWU42ZHJBamxiMTd4eDd0ZzhCQXI0R2pRU0xmZHN5?=
 =?utf-8?B?ZHZrRDNWdzRUWER4OUZCbnp6SDdyOFM5c0ZYZlo3cjBmRG1ZYkRCRmR5VFlp?=
 =?utf-8?B?QXlXcll3SXVZdm82U1dBQTRLRi9UK0s5Y2NvcG9XSVRpZWx1cDNTK29TbnR3?=
 =?utf-8?B?eDBPVC9UOXB2VlV4dVBhSWcyYWxTRnV6MWJ0d1J0cjNLL2VLb1J0RG43L0to?=
 =?utf-8?B?SGlvTWVXQ0VleDRWTTEwMEVzKzRjMzRpd1lKa0pTM0FYZ0J6eGpPL2lSVTdK?=
 =?utf-8?B?T215K0RCOGtkU0Y5aHQxU0N3cE5mWnoxNU9XTk9YOWFLdGlwa1FhNUE5Y0Fw?=
 =?utf-8?B?aGxZazA3NUxaOXU2dEV0bXdYM0gxTlZjdlBvQVZlUC9sdUNOOUFXNTcyTWly?=
 =?utf-8?B?MDNmYjBTb21jVTZmMDd6S3lJbUNadTBLclErL1JrZnRRRjZkNVlrNHJXNDV2?=
 =?utf-8?B?dlFTMUxncndJNXhBdlh1UENPZ1hpZWphR3RHcnduWStYQVkzSm1Bb2V2eWNu?=
 =?utf-8?B?Yk5OZDQwNk1ReWlybHlkQWEzQ0xzNFZMNEZoT3ZwdUxuMTQ4YnQwaWI4K1JF?=
 =?utf-8?B?UzRoREhDVW1XVi9rMFZ5SHIzMHMzS2JWWUtpaE02TmQ5b1ZrYjFheUxwRVJZ?=
 =?utf-8?B?L0tlcTJLakpibjZ1b2o0RE5Ob0NnMVd3TWRudklZWWNoMFY4MGlqTlJGTUpN?=
 =?utf-8?B?eDVZdXRESW5ZNVVvT25YVkF5Ui9iTS8zbEI3Q25TSnZETWhBSmhnNHlyUUhy?=
 =?utf-8?B?Yjkza1FuMkl6bHFOUTJGUDArbnNmeUdWeG42WTdrTTUzWE83akE0Ujg4Y3E5?=
 =?utf-8?B?a3p4Z3VZUXl3cTJreTZCNmplaGZaQlhxL3Z6d1BPcWltb2YvVk5YNzhFWWJv?=
 =?utf-8?B?TjhkdWRSamlYeG9Sei9PcDRwWCtaemxpQ2ZQaWluQXZ1ZEZ1SnJxMm93OHp6?=
 =?utf-8?B?dUdyOSt1bkZBM1U5SDFMR0hacnBsN2V0WXorOEdKVnF3Q2hnbWhoYkFVN0Nl?=
 =?utf-8?Q?ARcm26xstyoETLPt4OdnVC4I7ZJs20sw=3D?=
X-MS-Exchange-AntiSpam-MessageData-ChunkCount: 1
X-MS-Exchange-AntiSpam-MessageData-0:
	=?utf-8?B?VGVPclBOVm5HYld1VTdMT3VmTDBOL1VEK1hxNmtOUlpKUUZnUW9tY3dwQXBW?=
 =?utf-8?B?dkdMd1JlUy84M0tSQlFsblZ5K3ZMejNPU25tU3o2K05jdUpaWFBtcWFhNC91?=
 =?utf-8?B?eHZ4RDNNMEVKRGdUZXpTVlNmaG1zUnZYOUVVU1QzUDByVEZ2bC83N1RTQmFZ?=
 =?utf-8?B?UzNvSURxUU13QUVRWTBCanY5NS9WQldFSmVBMVg4QU1pM3BSMTBlTzVkV0VK?=
 =?utf-8?B?enM3YmVNc0xGYWtQZndJVWM1aU9QUUU1VXkzeFN5MVV6MU52UExkUzFjYnVr?=
 =?utf-8?B?WGZaSy8xUXd0WXoxclJZQzZaVkdNb3RibXgzQVN5SkQ2eHFWRXdTM21LM28v?=
 =?utf-8?B?NVpKZXZGTXVLZ3dISzJ2bG9LTWttcGxPQVJBbW5JeTA1Q2ErM2NLS2V3WGRz?=
 =?utf-8?B?Uzc5eUM5NWt6N2l1dWJJVHdzMCs0Z09kTXBLRzMwMjhnZFBqc0YxdXlrWGNG?=
 =?utf-8?B?dDhMNk80WkI4c08yWUM2eHlhbE1TMWdRNEs1QWxRMzNBb3hZNUJsZ3FjZ1V2?=
 =?utf-8?B?c2RGcjJrZXBnK1NFTWpEcmZVVGJiRnJwOXRxRzhPNlg2M1ZtcG1xNlFxamg4?=
 =?utf-8?B?S3F5M0hOSVdzREUweEVVbGF0RkpOaFRaMkFDU0NVZEI2czRwL1NuL1hTZmxn?=
 =?utf-8?B?SkRIT2FnSnVuT1BGSzV4a1c4ZFk4NFlQK3IxOWNxZkVkOG1UNVlFZmg2TG9J?=
 =?utf-8?B?VHRHQUIxZzIxV2RueGFpZlRKM0NsZmRSWWRJR2xJQzhZVC8zOGVBWU0vdVJz?=
 =?utf-8?B?aXVlZmdyZlgrbkNQNDg2dU5GOFFVQ2FOa3NCUUtpenFNVWhtSWtiQTgzVFg1?=
 =?utf-8?B?cEJVbVBLckY0ZmEvRjNaYi80WGJuMmIwaS9Pb1VEY3Q5VmZlbFh5UWhTdjRY?=
 =?utf-8?B?dTE1NWFhT3QzTTkvbGkxbzNqYWNLcHRyRUgydnFUWkw5am8rY3gwbzJkc3ZR?=
 =?utf-8?B?NGRHSUh6c0paYUFLbVN2cUJKSHF3L0JVRmlES09OYWVoYmVSdFJHdG5sSS9F?=
 =?utf-8?B?dmZrRC9qOUY0eDZ0SUVRNC9aVWpMNStQR0t3a211M0hJc25CYnBrMDhwazBo?=
 =?utf-8?B?bUZtSmYzdWhoQ0hZMGdMVSt1WmdnMFhOeGNXYVpxWFVIZjRhaDlqdGgxOXJ1?=
 =?utf-8?B?STJVN1VhSDdOT1dISmJJT2k1MEliUnErK3Z6N0xXZVZqbFNmbGZLUHBFL2xp?=
 =?utf-8?B?OTRKS0JCdDFoRGNZdld0bWRXSU13NEorOEorZEdKeTQvd3hOSkUvWEZBRENy?=
 =?utf-8?B?eDlpQkViWlYxSFR5SytKMlNOWk1KVEhlbVZOYkZubEpmQmUxQUh1N3dzcEhC?=
 =?utf-8?B?YWhYdVc3dkdiVStaakh3MzBSTTgrU0JvMGhIZlRxT2ZSdmZjWlN2NkJ1WjdU?=
 =?utf-8?B?Y0JZUkExendmbXl5M25zdTJrUW9FOUdYZ1VyaFk5dVVkVklZMDR4elNDOGtY?=
 =?utf-8?B?U0pseTdjTEhMa1R0MDdqMndFSy9ENWx4NENXS0tRRUpzbW9ubTFiUjhSZnBL?=
 =?utf-8?B?SXBFRUtseFBwSEtYOGVOMDN4SDRTY2N4bGxkVUxGR0IrZU5yUGRsVkJoZHAx?=
 =?utf-8?B?OFQ0dEd2aUErbTQycmNINmp2UlpRdGFkT3RiV3lCOE9RV1ZmTm5aTi9DaXBS?=
 =?utf-8?Q?ls2XrR3NAQmp2jXVFYN6auSkdexZkljy/p0H5upshSEM=3D?=
X-OriginatorOrg: sct-15-20-7741-18-msonline-outlook-1cf9b.templateTenant
X-MS-Exchange-CrossTenant-Network-Message-Id: 9cfffd8b-ac40-4ee0-26a9-08dd15f505e9
X-MS-Exchange-CrossTenant-AuthSource: BYAPR12MB2808.namprd12.prod.outlook.com
X-MS-Exchange-CrossTenant-AuthAs: Internal
X-MS-Exchange-CrossTenant-OriginalArrivalTime: 06 Dec 2024 12:53:47.0749
 (UTC)
X-MS-Exchange-CrossTenant-FromEntityHeader: Hosted
X-MS-Exchange-CrossTenant-Id: 84df9e7f-e9f6-40af-b435-aaaaaaaaaaaa
X-MS-Exchange-CrossTenant-RMS-PersistedConsumerOrg:
	00000000-0000-0000-0000-000000000000
X-MS-Exchange-Transport-CrossTenantHeadersStamped: DM4PR12MB7525
List-Id: <pgsql-general.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-general@lists.postgresql.org>
List-Owner: <mailto:pgsql-general-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-general>
Archived-At: <https://www.postgresql.org/message-id/BYAPR12MB2808635594F3C83188FA5862BA312%40BYAPR12MB2808.namprd12.prod.outlook.com>
Precedence: bulk

--------------bHpvl3AGp9AEy0zsv0fNadq0
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit

Resolved.
Thanks

On 2024-12-06 7:40 a.m., Arbol One wrote:
>
> 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;/
>
-- 
*/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 [ í ]
--------------bHpvl3AGp9AEy0zsv0fNadq0
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: 8bit

<!DOCTYPE html><html data-lt-installed="true"><head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
  </head>
  <body style="padding-bottom: 1px;">
    <p><font face="Helvetica, Arial, sans-serif">Resolved.<br>
        Thanks</font><br>
    </p>
    <div class="moz-cite-prefix">On 2024-12-06 7:40 a.m., Arbol One
      wrote:<br>
    </div>
    <blockquote type="cite" cite="mid:BYAPR12MB2808E99A12528CA6DD26D2A9BA312@BYAPR12MB2808.namprd12.prod.outlook.com">
      <p><font face="Helvetica, Arial, sans-serif">When enter this
          commands in psql : <br>
        </font></p>
      <p><font face="Helvetica, Arial, sans-serif"><b>sudo -u postgres
            psql<br>
            CREATE GROUP arbolone_dev_group; // Create a group<br>
            CREATE ROLE company_admin LOGIN PASSWORD 'myPassword'
            CREATEDB IN GROUP arbolone_dev_group CREATEROLE; <br>
            GRANT arbolone_dev_group TO company_admin WITH INHERIT TRUE;</b></font></p>
      <p><font face="Helvetica, Arial, sans-serif">I get this error:<br>
          <i>ERROR:&nbsp; syntax error at or near &quot;INHERIT&quot;<br>
            LINE 1: GRANT arbolone_dev_group TO company_admin WITH
            INHERIT TRUE;</i></font></p>
    </blockquote>
    <div class="moz-signature">-- <br>
      <b><i>ArbolOne ™</i></b>
      <br>
      Using Fire Fox and Thunderbird.
      <br>
      ArbolOne is composed of students and volunteers dedicated to
      providing free services to charitable organizations.
      <br>
      ArbolOne's development on Java, PostgreSQL, HTML and Jakarta EE is
      in progress [ í ]</div>
  </body>
  <lt-container></lt-container>
</html>

--------------bHpvl3AGp9AEy0zsv0fNadq0--