Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tEE0f-0064oV-O0 for pgsql-admin@arkaria.postgresql.org; Thu, 21 Nov 2024 20:42:41 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1tEE0e-0016aT-Bx for pgsql-admin@arkaria.postgresql.org; Thu, 21 Nov 2024 20:42:40 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tEE0d-0016aK-Rw for pgsql-admin@lists.postgresql.org; Thu, 21 Nov 2024 20:42:40 +0000 Received: from mail-mw2nam12on2127.outbound.protection.outlook.com ([40.107.244.127] helo=NAM12-MW2-obe.outbound.protection.outlook.com) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1tEE0b-003A8K-9v for pgsql-admin@lists.postgresql.org; Thu, 21 Nov 2024 20:42:39 +0000 ARC-Seal: i=1; a=rsa-sha256; s=arcselector10001; d=microsoft.com; cv=none; b=xf71KDeXqVRjuLUQIBv2j3qamlfIg+c4phKygXxqA0j+hQlW4UGg4GagyKsSuK5Gyy7IlZsDJYOgvlHo4Kgo72U0EqQZwh//YXdJb0f8+XLAjNpYIR4lln2s5ztBx6t4gNPzFuMf9gpnCO6MxlTfqFqQAvHWNMEorJrCFJQ0zGH/FqPmMtx1Jq7BjWeDZjwUGILDkccNrtSeYQRNSTu6Kel5kIYABTl4rhckDNSfPMgO1FWzP4HA2qfNHc9Fur+u4WvAMr1T/TCUfyUIgBFUxnkz5vyG2fhWhh4bvZh8l80i3XG/U2kO5Hqh0F84mBDq/6gKPHA18sAkVFEiS9gcRw== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=microsoft.com; s=arcselector10001; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-AntiSpam-MessageData-ChunkCount:X-MS-Exchange-AntiSpam-MessageData-0:X-MS-Exchange-AntiSpam-MessageData-1; bh=XrRtd/mmSvR58k3D31TbGkLfL8n8GkuimwDhnNAnhYQ=; b=TqNVsR9Z0zKO/Lohw83Na8h+9CpGFYFPibMpQhLBuyeGPrbkjQNRX1PqQFDY+6APHwP41vdiOed5GgCAdNYaunzG2RARXRMRUh2X52KL6u1/08rJ6BE7hU/y0E6kedizAduS9SyVE07ixAA8nB6v8AeLFygpz1aqknxWo+Qq/a3no1t+1PyPa0c2Me0ctFfaENtUkNNtp/ly5Ik5GqhwK7woObIRBvI8GX56w22sTaI1PrrGUIighanr3FF1Noj63WfFb5mrW+Rnu3HwAgNGcyAfXy35DW46hA/DDUIjCqHo+y8HVR9lFgpjCdUdHXfRIBr2Lcd30BOge4U/PSIPvA== ARC-Authentication-Results: i=1; mx.microsoft.com 1; spf=pass smtp.mailfrom=ilwllc.com; dmarc=pass action=none header.from=ilwllc.com; dkim=pass header.d=ilwllc.com; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=ilwllc.com; s=selector1; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-SenderADCheck; bh=XrRtd/mmSvR58k3D31TbGkLfL8n8GkuimwDhnNAnhYQ=; b=Fm7iwWDp1EWP5DTlkO/hRF9lR9EcSt22Onc3dM/AQ7XZDbKZmv2fCM8tiO1Ap8DV4cHi7DztIl9sMwP+1bbWrZluNBUqpBuE8WJP7vpCkL/a5QXiCNJpaBgbyMjmNQ73OCTOMIcBg+3FfqgBr9HxV/uaB/zkLfAQcETL1/jODmE= Received: from MN2PR18MB3462.namprd18.prod.outlook.com (2603:10b6:208:268::12) by BY1PR18MB5325.namprd18.prod.outlook.com (2603:10b6:a03:522::19) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.8158.24; Thu, 21 Nov 2024 20:42:23 +0000 Received: from MN2PR18MB3462.namprd18.prod.outlook.com ([fe80::f0d1:5beb:325b:e4e]) by MN2PR18MB3462.namprd18.prod.outlook.com ([fe80::f0d1:5beb:325b:e4e%5]) with mapi id 15.20.8182.014; Thu, 21 Nov 2024 20:42:23 +0000 From: Benjamin Patrick To: "pgsql-admin@lists.postgresql.org" Subject: Table owner change issue Thread-Topic: Table owner change issue Thread-Index: AQHbPCIn/fE9/Ea2vEGQ/vFTbtTjhQ== Date: Thu, 21 Nov 2024 20:42:23 +0000 Message-ID: Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: msip_labels: undefined: 1413905 drawingcanvaselements: [] composetype: newMail authentication-results: dkim=none (message not signed) header.d=none;dmarc=none action=none header.from=ilwllc.com; x-ms-publictraffictype: Email x-ms-traffictypediagnostic: MN2PR18MB3462:EE_|BY1PR18MB5325:EE_ x-ms-office365-filtering-correlation-id: 3b029565-332a-4767-3048-08dd0a6d008a x-ms-exchange-senderadcheck: 1 x-ms-exchange-antispam-relay: 0 x-microsoft-antispam: BCL:0;ARA:13230040|376014|1800799024|366016|38070700018|8096899003; x-microsoft-antispam-message-info: =?iso-8859-1?Q?6Zty2PDl/1g21lChkig2aktdaH8ZSxNhkjU1cbz6XR4vXESLnBRRkmAkyP?= =?iso-8859-1?Q?zhKt8ZUjHp0WceYNpSIx1Yi/3m7rmuNZnSrmMaLvIZRkR2EvJB3oAe7L2y?= =?iso-8859-1?Q?0uBHJveOeF0L36IQ84iQvRzHGSytl0Zkv/L/mIMQxla8cM1h3E8GBSGlgi?= =?iso-8859-1?Q?nbbnLiuVDkkf9l+hxeh8/S8fdjEx2bBy/m2mH2cyabBh0V6eT+wM7r1/dg?= =?iso-8859-1?Q?su/SSpgitB89WDU/NiroJvmXby+8dHrKi0UZqAV0wuTqEM3s7xqbLeAtn6?= =?iso-8859-1?Q?+Yen3IBlM1Rn4+9ztIgyABwAib3tWwDWyMVvvb3lnjdjmVRizuqR7oHo1X?= =?iso-8859-1?Q?dD38Ny2hCye6tyB87yxoXjEVtf/T0dLDlKJwxdWiElxuDpJTVky80x4vTk?= =?iso-8859-1?Q?uZdT1SGzucj3JwHeUnhpWQhXtXA6nLca2Bz4JH42XDqffHudGy2RnpVa6k?= =?iso-8859-1?Q?YZhlyQVMUUOAaaiWox0tikx6aBjhvi1R+2QsfeqvcC5brYPt5Vt+sBEf4J?= =?iso-8859-1?Q?HPeASsIo+2eA51tU+cG2LigIFSDHRIFlk68a70zcLCW0MAecZ2R/2yaUVs?= =?iso-8859-1?Q?o0wJd85ZpgZT3lKGcJRfAISoh7MKYcJCC1SdnIb8dUc/jCUPNSiBAqP8mj?= =?iso-8859-1?Q?JjY99qBtPF1bEhRx34znZgoVadjtyNjcsBCIiimU54RVRXTDkvU7GMiN6c?= =?iso-8859-1?Q?ZAubZ68jnfm6tk8LpU5Qp8nz9OCPhBWkSA7fbD6wOghA5+k6G5aKVT4vth?= =?iso-8859-1?Q?pN2suhhHHyuCV/F7rYDA2HhJ5iq/wN0FGfGB28NX93s12Qx8dV2j6TlDYE?= =?iso-8859-1?Q?MMoIPejh73RgsDfGoq3RLHN/ya9tVlIvhByiLzR2ZtjOVcsFPChdG8f+2z?= =?iso-8859-1?Q?cyWa+sNaPJtTt8X0TkS4mNepfz0c+9D/82eYmTDlqL3MSJXQkEODpCu1tC?= =?iso-8859-1?Q?OtKjKDKSFfUzF6CZyZt0hewcybK0OHaHXbgLok0nXpy2aeULOM/iDeGbuk?= =?iso-8859-1?Q?EM8VBiXj2jcighBbKAG4/Zp5ACDsIeLWH1glg4ihM1pMB2bwlPj5xdUZ+4?= =?iso-8859-1?Q?hVPKIBPdeEBTEfZAE7awbkkHiuI7Z8jOrB6QfoOnkHlc/6Vh/ul475wuZ/?= =?iso-8859-1?Q?u7LXiShPL4BCc9UmVN3G1l+6zB59ZJ/5qBbAh2Dqhk5WktUlamNG648+Sf?= =?iso-8859-1?Q?Vsdzpz3nPUlhpnoHcb+PPumHtTJOP9DJtUJcRluupHLF0BZ/PObUh8h4m6?= =?iso-8859-1?Q?PoDrd8ZT0hQFDPfb7DMAgwNeXCiLsgjFDB+kSui5UVsWzdpqtqHOPj6KeE?= =?iso-8859-1?Q?OtWCM9sX8MCCNDLGMwDMvxjS8yTVbu+JidMwtU/y6RklJxOi+lGxLi9SV5?= =?iso-8859-1?Q?9HTpPuski0Qpmgqa+ZlXUh6/sJEUdFGWqsaHGH0jGyZrv8BfkqiMo=3D?= x-forefront-antispam-report: CIP:255.255.255.255;CTRY:;LANG:en;SCL:1;SRV:;IPV:NLI;SFV:NSPM;H:MN2PR18MB3462.namprd18.prod.outlook.com;PTR:;CAT:NONE;SFS:(13230040)(376014)(1800799024)(366016)(38070700018)(8096899003);DIR:OUT;SFP:1102; x-ms-exchange-antispam-messagedata-chunkcount: 1 x-ms-exchange-antispam-messagedata-0: =?iso-8859-1?Q?UQTvEjnQkbpEqNbimcZ0k+/bAIIcR6lWlFMN1S8ha7qoFkrenktgSAv8uu?= =?iso-8859-1?Q?7KWpoftkJY/ehd19urQK4Xg9xjR5G5M4/UycEFoMReomkClmgGyL8NGEa2?= =?iso-8859-1?Q?6CNBLR55Sq333vYK5yUjqKmMR5XkDeAcJtTjdEwCJSlmQfVlCqMRFVb1TV?= =?iso-8859-1?Q?oM7BKQdcb/Ve0YuP+OA8FhiLy0XfFEJOnB3z0+ndXQEwaNukDnUJKKHhyv?= =?iso-8859-1?Q?a0r5uEF///3EnHPxmZ+CCJCOrNTo8K1+gv5sFNjjiaz0V/7t1O95ECaiPR?= =?iso-8859-1?Q?yVlZBy+Q465RajyUoz2ee2TtMdtT315Eq9CsIS/vSg9AJVdrv9I7h2h5R8?= =?iso-8859-1?Q?ifmWW4r0JtX1zZivgomIgcYxxaNmjbxVymWghuGWb3/PkxIXXEt3wVPz0H?= =?iso-8859-1?Q?+vawdYb4gJcKQ8HEl6SkQO8rQAHHNBHiFwA3Cc8+dxkZimuAqSbaRCri1n?= =?iso-8859-1?Q?g6yHetGP4GRqLonozIO9eGIfOieJYOxQffJkGVCyQsjROE4qdoUGY3iyvp?= =?iso-8859-1?Q?4kMyTQCNDGl3qbaKUsaAT5iIdKs0byY21VcaGMVydzxgZkQuuZnDtVi5sq?= =?iso-8859-1?Q?fmwA/GSJYhiFO97lXMoJbz6rJpcZF73UfRFVTfxjhZifCrSCDd6cUucmCK?= =?iso-8859-1?Q?pMtFUWwRNGrgZYool06AZZR7MHuIyuuFfeKfk4Co+NcW99eQkqIqDyZtjx?= =?iso-8859-1?Q?ytBsZzkbfI82tKq1jAFDQc84x68nPX3JPwnONgVo2J3xjD5k44BWw0vGF5?= =?iso-8859-1?Q?pH5vZxIR+CgimgHZTKoX+5GkOCBbe5WlbyfPtAAY0KVgUO0wMvQi1y/zNg?= =?iso-8859-1?Q?/x8A+Nfb/T5GbGhScRyZdsALJnm7Yx9GLp+u1wDptX3/nnDl/YdrVZkcJz?= =?iso-8859-1?Q?PTJU2YYXtp0Iqe7Kctc6eU85+wrq8pX3X74sQMYbxs/yOEVObA//JKhQrT?= =?iso-8859-1?Q?T6qUXffBnfPMHzjQGf0fOVS8N/I4Hc92NO856XO31Vmw3vVFP4c2X7ownj?= =?iso-8859-1?Q?N2HNucnd7SmUcVhGdASYLMhoaVFYoFoF3+Bh46MhU5UnDjFgHiFpVoJUNL?= =?iso-8859-1?Q?s3VRux/kvF6j9E+IV3gPzMQFuWcG71mv4TV2jV6lqjGiNwp3xjkVRvFoLv?= =?iso-8859-1?Q?urQU65V++eGq7+jzJtm9u8bOBwiG/QSsKzOcOESqxFdNnm8uO3kehbx6xp?= =?iso-8859-1?Q?+m403SJhOFucMuEIFbHlkeD4QZt8qR6nJQLoGLApudt1KHFJED3T/1Nwe3?= =?iso-8859-1?Q?VYyE5xbtq0VeXRxv/wzhwwHI59DndCTS04O3rtTD0aML4ccL7QrYPpAsCQ?= =?iso-8859-1?Q?69jr2WAmgRVItBq2zCNmf4jO1naLrXaMg8ESVE1yCyZobnmXUO0rT3Fra1?= =?iso-8859-1?Q?Qte2TfJWUTvYuL0fu8gHVGJdzwexCSaFiCyLh5aeT8eBl5yXh25Jarmou4?= =?iso-8859-1?Q?F6spVO2J/leGoqGLWzQyhLFS1fhN0ddYSN/j4uZ4U7vK9tjSM1+fkq8nmB?= =?iso-8859-1?Q?Hp5XPkDWZKleaRI3hQQ1cbW9n2ozvooHJQqul8RB6PI1Lx6MbNHqgz043F?= =?iso-8859-1?Q?L6pZd3gznWK/i+TETpE8gFXDU8PRTnBBJf+ffIPnWPBzGx3EHIekWX/Lcy?= =?iso-8859-1?Q?Xtmg7uGLvDRSAzWfZyaN+cruilAVPr2NGFixwFOSUe+dPBCs4ojRImfg?= =?iso-8859-1?Q?=3D=3D?= Content-Type: multipart/alternative; boundary="_000_MN2PR18MB346262E20C3F101F7C1A8324F4222MN2PR18MB3462namp_" MIME-Version: 1.0 X-OriginatorOrg: ilwllc.com X-MS-Exchange-CrossTenant-AuthAs: Internal X-MS-Exchange-CrossTenant-AuthSource: MN2PR18MB3462.namprd18.prod.outlook.com X-MS-Exchange-CrossTenant-Network-Message-Id: 3b029565-332a-4767-3048-08dd0a6d008a X-MS-Exchange-CrossTenant-originalarrivaltime: 21 Nov 2024 20:42:23.2819 (UTC) X-MS-Exchange-CrossTenant-fromentityheader: Hosted X-MS-Exchange-CrossTenant-id: b369dc7c-4f98-4bc3-a144-7c92cda913de X-MS-Exchange-CrossTenant-mailboxtype: HOSTED X-MS-Exchange-CrossTenant-userprincipalname: 2VyROVKf4O4gpCiTpftpTk6ZsJb24axsHQKhfUnGYPYSWOBY5BmJAG8Im8QomL95QY1oxy2OoSwYGddNm6bNTSRGws1Ek3m/aDF14Ul2t9Wx5LWf462/BSLJx8amGT1c X-MS-Exchange-Transport-CrossTenantHeadersStamped: BY1PR18MB5325 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --_000_MN2PR18MB346262E20C3F101F7C1A8324F4222MN2PR18MB3462namp_ Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable I am using PGAdmin 4.8.8. New to the group and hoping this the correct gro= up for assistance. My instance is an AWS instance so there isn't a viable superuser. I had a user create table with the table owner being themself. user.schema= .tablename I wanted to change the owner to the dbowner, but was unable in pgadmin or s= cript. dbowner.schema.tablename I had the user run a script to the change the table owner to the dbowner bu= t the user received an error unable to set role. This occurred both in scr= ipt and pgadmin. The table owner was able to change to a mutual role that both the user and = the dbowner are members. From there the dbowner was still unable to change= the table owner to the dbowner. Any assistance would be super helpful. --_000_MN2PR18MB346262E20C3F101F7C1A8324F4222MN2PR18MB3462namp_ Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
I am using PGAdmin 4.8.8.  New to the group and hoping this the correc= t group for assistance.
My instance is an AWS instance so there isn't a viable superuser.
I had a user create table with the table owner being themself.  user.s= chema.tablename
I wanted to change the owner to the dbowner, but was unable in pgadmin or s= cript. dbowner.schema.tablename
I had the user run a script to the change the table owner to the dbowner bu= t the user received an error unable to set role.  This occurred both i= n script and pgadmin.

The table owner was able to change to a mutual role that both the user and = the dbowner are members.  From there the dbowner was still unable to c= hange the table owner to the dbowner.

Any assistance would be super helpful.


 

--_000_MN2PR18MB346262E20C3F101F7C1A8324F4222MN2PR18MB3462namp_--