Content-Type: multipart/alternative;
 boundary="------------p6GpXks4ycesb529bb9SGbGq"
Message-ID:
 <BYAPR12MB2808E99A12528CA6DD26D2A9BA312@BYAPR12MB2808.namprd12.prod.outlook.com>
Date: Fri, 6 Dec 2024 07:40:07 -0500
User-Agent: Mozilla Thunderbird
Content-Language: es-ES, en-CA
To: PostGreSQL MailingList <pgsql-general@postgresql.org>
From: Arbol One <ArbolOne@hotmail.ca>
Subject: GRANT WITH INHERIT ??
Organization: ArbolOne
MIME-Version: 1.0
X-MS-Exchange-MessageSentRepresentingType: 1
X-MS-PublicTrafficType: Email
X-MS-TrafficTypeDiagnostic: BYAPR12MB2808:EE_|DS0PR12MB8413:EE_
X-MS-Office365-Filtering-Correlation-Id: 14f24467-5ab8-4fcb-cda4-08dd15f31ef7
X-Microsoft-Antispam:
	BCL:0;ARA:14566002|5072599009|7092599003|19110799003|461199028|8060799006|15080799006|440099028|3412199025;
X-Microsoft-Antispam-Message-Info:
	=?utf-8?B?QnQzM1l4c01QVVFNTGhvWmRRRGNnK2NibTEyVStLY3Z4OEVycjRwcFgvVzYy?=
 =?utf-8?B?UVI2M29iTmErS0tXaUtkU2ZjVWpGelVFclp0VEZ0ZTRQRVJGSGNuK3EraFBU?=
 =?utf-8?B?aC9uRzBHMjE1K1FXOG1xZVdpaStrd3BHOXFOZkZWU0Q1ckJDbGxKUFgvZUhV?=
 =?utf-8?B?dnQrRXdnU2hIcWFpY21VdHVldjVUc1ptek9YeTdVUVE4eGZNYkkrVFFDcDRv?=
 =?utf-8?B?VEpDY01yMXBFcWM5YnNPek02R2ZBYlp5KzRGbmcyY01uR0JEa0pBbE9iaFUv?=
 =?utf-8?B?U2l0cDhvUjV0MTZSK1d0djBUTmlrb3hMNUt4SW1Ed1JXSGxNbUF6SjZYQ3cy?=
 =?utf-8?B?TmlHYm9nVUJWbFJIM0ZQV3V4OGZ0emlvb1dPaTRwNEY1UmNpVWdaazVaU3FP?=
 =?utf-8?B?cTJLbS9wOWI0YkdhVmZuMDBBSUZhb0xOQ2lqRnkzZVY1SXZxSU56dDFnOU5z?=
 =?utf-8?B?N0tpdVdNYldUVFB1VlRydnZzdGp6cVVzM1pRUDhxZ1V3L1pxYUJWVkxHbXpn?=
 =?utf-8?B?UFd2bW9IM2pSZHpCekNYL2JYY3ZweWcrVXhVZHIycmltVitjT3VKS3p2RkpH?=
 =?utf-8?B?VC9HUGhNMUZCcVRRRGVxTzJqc091bkV3a0xVMngrTDlYSXlQTG5sekdIY3Y2?=
 =?utf-8?B?aUltNFN1M0N1d0F2YlJXRGQ0ZlY1T3UzY01LRXR5b2ZBYVNyakhLYXVFalVo?=
 =?utf-8?B?YXZ0MWYvdEorUDEzYVo1WG9NdEVGM2ZsaUxqRmlHYkNWR2lLNDgyeVpQQ3lO?=
 =?utf-8?B?MDZNNTNOUm9HQXZud3JXT3hzR2NERHVrNG5IbklRNHYzTkRhQXpSWGtyeHRa?=
 =?utf-8?B?aC9lTjE2TVIvNEJSd3dTcTl1VEpheGd2QUFsTkdub2k4b2tLS1FwWmZZS2xY?=
 =?utf-8?B?RDRJdW5pMktGMFNaclJ1Y1c3Q3JxQ2MvYm9GR2Irc3d0V2NJZU1iTCs4QVhN?=
 =?utf-8?B?NlZVRk14aHRNaGUwWVZVTEJDODU2YzJOTDFmWVpsNjhlSWhwQUg2T3Z1aWhh?=
 =?utf-8?B?alhib25pVmkrckNOREgrMFRleGo0VHlGamhmOVB3a3RaQUp3Sis1YlVzNlFW?=
 =?utf-8?B?b2cxZ2NlWGpiQ2RUcW1Cam5WQXViaUZoMHBFREIxSmVHRHdZV0Q3eWJYM1pI?=
 =?utf-8?B?K3pRcHBNSUhIQ1M0K3Z0NnpUWm0vVXFOWWIxei8rTWpZMjlqS1czWVpJNnlW?=
 =?utf-8?B?V0FOVXR5Zzc2bkJpcHJpU0hJZFdCVzlGa2ZFLzcrRmE0Q2tWYmRoOElYcTZ6?=
 =?utf-8?B?NTU3VlV1NkM3OFdMZ0pDSlJzb1JzQzMvSFBZOUlTNmdwOFJ4NFFJUk0za21y?=
 =?utf-8?B?M2s4djZGdmlaak82RDRJUWRoVEg1VjFhajlHeWxSRUdwdXFhRUh4NUxVakpl?=
 =?utf-8?Q?LOhQeymeizAHns1CXfUkf80qXsLtYsVk=3D?=
X-MS-Exchange-AntiSpam-MessageData-ChunkCount: 1
X-MS-Exchange-AntiSpam-MessageData-0:
	=?utf-8?B?Vi9hTlpOWElaMzJMWkFaZGNPcmt1cUV1a3luZFZzRXlseTc1UGFWTFAwSlNW?=
 =?utf-8?B?QytQNTNmSVFLa3NqNGIyb0NmdFZ3a2pPSmEwR1lhTS84UDlxM2RvZDljeWpO?=
 =?utf-8?B?MnZwMFRPTzNKSGpnZjhyUThYVFpvQXdSd25NUUFCTUZDTHVyTFphR29aNWYx?=
 =?utf-8?B?eUFzSHFubVVGelphVlR3U0lKNHpkVzVKcXlHT0JiUnpYUFJkOGgvME4ycnVX?=
 =?utf-8?B?Q011dHRTOFpHeGdtbzBOQTJrbUJYbjIxeEMrVlg4NXoyV0NXZXVNdkVWRHlZ?=
 =?utf-8?B?aUd1YU1pYy9aY3NvVVJYVjBVV01uVlR5MGx5QXk2L1gwcVpDMHBpK25TR1NW?=
 =?utf-8?B?TmZVR1BtclMvTkh0Z3pLS1kvOGpIQU9lK1gzamk5MnkwcFN5UlBoQS8yeUU5?=
 =?utf-8?B?WHpxbFduMWxhT05wRHFxeEwvMnRRYXRJem4ySGlHSDJVR2NVTEtWUk9nK2pI?=
 =?utf-8?B?SzNrd0IvS2twK091azFxTEtsdG1ycE5vc01QUVRBWU9TQVVQWERPYlM4aUFm?=
 =?utf-8?B?UWtKbkc4THJVcWdJT1RVNm1hVmF6NUZBc0EvdlV0ZE92KzJxSjJrUS8vMEN4?=
 =?utf-8?B?akJWQzRkU1JsTm1uWVp1UnN3VXdSNWR3TUkydW9iSEt4bzFZOUlQZ1ZYUkNM?=
 =?utf-8?B?M2ZROC90MWNPZlY1aUp5ZHBPYWlYWE1ZMDF1TU43NG5NYzdING92YmZOUmo2?=
 =?utf-8?B?SFd1OXU3WVhPbDFNS0ZVTElWaEgwUVFPSXlmaVBoUFhxQTk1ZnUzOStQb1kw?=
 =?utf-8?B?Sm9FKy9RbllHNGVxZURPbWp6YUZUM1VSQVU5K2Y4K1UwL0I1c3V1eWdwc2dW?=
 =?utf-8?B?OWZvRGtLa3d1R1BzTDhaNjJJVTF2TEIxYVBMTUFiUDVHWGVlQzk4QXZWOWYr?=
 =?utf-8?B?WlBpTzFadTlTUkxHUHNBU01RL1dBVGZETlc2RmhPN1JxT2dTZ3p2MXJYL1NJ?=
 =?utf-8?B?dlFCMjFDZ2tVVHRySU1TQUFpbXBzSVpBaEtvQ000aTNYRktjanB5bktiaXo3?=
 =?utf-8?B?N2lBcTVudzVzbnlvbU1TVjlGM1lpZkt6YWYwa2pSYUs2WmFWZmt1ZDBwcDNo?=
 =?utf-8?B?LzhZUUc1ZjRVZnZINDhsN3J0c2R0MzFKcCtJODRHVTZreXRGdXRCczE3ZnhF?=
 =?utf-8?B?bk5YREtiYzFMeEMxb2JROHFPbTd0RnFxVEFMcmEzUmRRckliYStOcG1jVGlJ?=
 =?utf-8?B?TWtZQndVdkliVlJHK0xsVjJCaktxazgxd2R1eWRsd3AvcUFhZTJsSnUwTkZz?=
 =?utf-8?B?aU5OZGpKSFczeXBrUmlNZlNnSDJDd2UwRUxGcjNBSngxVVFDVE54cGZnNGFL?=
 =?utf-8?B?L3kzaU5oYSs1VkliUWdPVGJaTGpNM0V1QjN6SWZwVXQwUVZQa2lnYjRkTFJZ?=
 =?utf-8?B?TjFQSHg2V3RkUVAxayt2RDRlaTlGeG5kQVRydkFNYm5HQ0tOOHJFeVoxZ20r?=
 =?utf-8?B?enYrK1ZKY2o5MTZ2djVyS2V1cGI2ZjNtZVFrNmYvc3FpcjlCRlQ0TlBBa3lN?=
 =?utf-8?B?TmxuUEdGeWxjUjFZd05LZ3kyZG5MQjU5ZG14Y0hmTUc5aHNaUHZscGQ5ME9s?=
 =?utf-8?B?L2poakhPQzhwOUZuT2p0d2RNb05NaVZuOWNlZzNYMDdaWERBVjNVbUZrNkRs?=
 =?utf-8?Q?Vvo5xhK1gD1yxJ8z/KOXQLVc6ytkdww448yar9+HJ0gg=3D?=
X-OriginatorOrg: sct-15-20-7741-18-msonline-outlook-1cf9b.templateTenant
X-MS-Exchange-CrossTenant-Network-Message-Id: 14f24467-5ab8-4fcb-cda4-08dd15f31ef7
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:40:10.1194
 (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: DS0PR12MB8413
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/BYAPR12MB2808E99A12528CA6DD26D2A9BA312%40BYAPR12MB2808.namprd12.prod.outlook.com>
Precedence: bulk

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

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 [ í ]
--------------p6GpXks4ycesb529bb9SGbGq
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">Hello.<br>
      </font></p>
    <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><b><i><br>
          </i></b></font></p>
    <p><font face="Helvetica, Arial, sans-serif">Is there something I
        missed?<br>
      </font></p>
    <p><font face="Helvetica, Arial, sans-serif"><br>
      </font></p>
    <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>

--------------p6GpXks4ycesb529bb9SGbGq--