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 1qzOPr-00FzG1-TG for pgsql-general@arkaria.postgresql.org; Sat, 04 Nov 2023 21:42:52 +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 1qzOPq-007YTO-CX for pgsql-general@arkaria.postgresql.org; Sat, 04 Nov 2023 21:42:50 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qzOPp-007YTF-E7 for pgsql-general@lists.postgresql.org; Sat, 04 Nov 2023 21:42:49 +0000 Received: from mail-sy4aus01on2130.outbound.protection.outlook.com ([40.107.107.130] helo=AUS01-SY4-obe.outbound.protection.outlook.com) by makus.postgresql.org with esmtps (TLS1.2) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1qzOPk-003z3y-IU for pgsql-general@lists.postgresql.org; Sat, 04 Nov 2023 21:42:47 +0000 ARC-Seal: i=2; a=rsa-sha256; s=arcselector9901; d=microsoft.com; cv=pass; b=QExFcg4o9Q6NOauCbfgPP8wy/S30rpHmcS01fVvFtL6UU1swptSDD/sC5sMr/g8aeCn/y3msBS6pxfZ39sXUB7vZLM4cT6MXXTEkVmOKk3+L4P9vZVWd4snza6GzuOFEV3ODnDb6JX2us3LOhTTT1gbbOL8IhfWH0G1KViO2LGUvKVMYvmva0pKGus0RV6IT4mKu93oYEoOw8UvREy/ZXJaYd9AtDK3Sv830U/oNT89yI3XCDBTN2gV/BZujnXhE19N1KOz5H8VAYsaXvJ2E0xicy7UP1dQTtguqZNLKKnK6dvggGeopgO5rxhaAmDztsJPC8+IL6LJBVoawyHL3bA== ARC-Message-Signature: i=2; a=rsa-sha256; c=relaxed/relaxed; d=microsoft.com; s=arcselector9901; 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=UOuctOLIOT1cArFooAups5qTzJ41jiZllrnA2olqVis=; b=k7A8WbkJNUhRd2zGhPwjL+/tqgJeLHIio2y4Hr9A/gb4LAIl1QbCpaalszRXEXJym21D3LuaNUIXauPKrhK6kZTMqO4FFyRFkehilwCXhMLxBdO6qbNvXw3eKz4Vf0LvI8VqD5tF8jhLIEwBLwU+fdT2y0uRUCtcxmRWGK9iaYlI90sz9ERNJL4TBh4bw9hRtqDYmnwn38/F6WWqCrJHOqLaMxh/kAa2szYDaf0zL8rN6CKzrvgRZxhAjIa+44rqepwGu0nZY42JsJQmLeDn16Z/mjD/GjTrZ2giOIDD1U2hhDOUfPsOFL7LljesfZONSiT7SY7regYxBLSoHZ6xqw== ARC-Authentication-Results: i=2; mx.microsoft.com 1; spf=pass (sender ip is 104.47.71.169) smtp.rcpttodomain=lists.postgresql.org smtp.mailfrom=niwa.co.nz; dmarc=pass (p=none sp=none pct=100) action=none header.from=niwa.co.nz; dkim=pass (signature was verified) header.d=niwa.onmicrosoft.com; arc=pass (0 oda=1 ltdi=1 spf=[1,1,smtp.mailfrom=niwa.co.nz] dkim=[1,1,header.d=niwa.co.nz] dmarc=[1,1,header.from=niwa.co.nz]) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=niwa.onmicrosoft.com; s=selector1-niwa-onmicrosoft-com; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-SenderADCheck; bh=UOuctOLIOT1cArFooAups5qTzJ41jiZllrnA2olqVis=; b=S1ZbRh32YD0v+bZLwkKmHZG8WaGhU7T/F5FyNny9Z7rDpW/vBOdR9Su/ZZpfaksEvvldn+S+YmhbRetyO0dLXPgp9NIHdJhW3s9Yp2HQDQsq6uQEukuNiWu9HscIequD3gordSynFOJUa31ElfWC8z5tq1dNlmD8R97D+5B8x2M= Received: from SY5PR01CA0068.ausprd01.prod.outlook.com (2603:10c6:10:1f4::17) by SY7PR01MB8574.ausprd01.prod.outlook.com (2603:10c6:10:1f2::10) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.6954.26; Sat, 4 Nov 2023 21:42:37 +0000 Received: from SY4AUS01FT015.eop-AUS01.prod.protection.outlook.com (2603:10c6:10:1f4:cafe::86) by SY5PR01CA0068.outlook.office365.com (2603:10c6:10:1f4::17) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.6954.22 via Frontend Transport; Sat, 4 Nov 2023 21:42:37 +0000 X-MS-Exchange-Authentication-Results: spf=pass (sender IP is 104.47.71.169) smtp.mailfrom=niwa.co.nz; dkim=pass (signature was verified) header.d=niwa.onmicrosoft.com;dmarc=pass action=none header.from=niwa.co.nz; Received-SPF: Pass (protection.outlook.com: domain of niwa.co.nz designates 104.47.71.169 as permitted sender) receiver=protection.outlook.com; client-ip=104.47.71.169; helo=AUS01-SY4-obe.outbound.protection.outlook.com; pr=C Received: from hamlmail.dmz.niwa.co.nz (103.229.249.34) by SY4AUS01FT015.mail.protection.outlook.com (10.114.156.158) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.6977.15 via Frontend Transport; Sat, 4 Nov 2023 21:42:36 +0000 Received: from AUS01-SY4-obe.outbound.protection.outlook.com (mail-sy4aus01lp2169.outbound.protection.outlook.com [104.47.71.169]) (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits)) (Client CN "mail.protection.outlook.com", Issuer "DigiCert Cloud Services CA-1" (not verified)) by hamlmail.dmz.niwa.co.nz (Postfix) with ESMTPS id DD02A609A86 for ; Sun, 5 Nov 2023 10:42:35 +1300 (NZDT) ARC-Seal: i=1; a=rsa-sha256; s=arcselector9901; d=microsoft.com; cv=none; b=eSeEBQxjkg5rNPvrYudMKGHCvr1NjQvNO/LzinHH/wbJ9ytTixSz+94sAquoEQw4YHS13Gzbz3CgIImJYUfvF9Dpn0EaIw/Ik0OgLKXD+JWDgt2NKjc01/wZdDy7E2tUDvTa6UWag1oZyG9C/PNYkTz2CUnSaPbUrOch+JOWXjoeoEUOcXLBj2Sjq/FIO/ZEQOk9ldjZzQc0zQQVBtkBZdoV+hIAZ6CVQWp4anBl7vxcXJD8enNCY3yxScZwj51n9BW0iLFLrRYz3YkMx/CtGkqwhD+bfQF1OnVIpSHABf190XkDUvtQMTXxHG3sWRqVoehMJHJI5Li83u6vb4K3lA== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=microsoft.com; s=arcselector9901; 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=UOuctOLIOT1cArFooAups5qTzJ41jiZllrnA2olqVis=; b=V3Se2L9H0DnOyfp2Ub3zYX68M+sjoiG8DWEZhaxRH0devvH4f7MACVhNhyYVY0+leCikfdocYoMFNSiea9z9Z4clzBsPHKhUSeCab101b7+fmP2CyLlg6YozbbZ918bNiQ53pSfNi1hrA7hOIoWxJ6ymHfPbFEZTLKMS69ZNByoCO7BNXl8HVHI1B5pn2cwFpk7VykTz0cncy4Hn8/y61eDjehtmaBVWGW0geL1tuLFFMYv0yhQy0ssz+R7d2bcyyLlgs7sqHZeemHZdsdwMTNPiGEOReZIUxXlzfPNpxEthp0/WbcgPRTfAwUf+v09TIcLsyy2/p5XPhnEziTNwew== ARC-Authentication-Results: i=1; mx.microsoft.com 1; spf=pass smtp.mailfrom=niwa.co.nz; dmarc=pass action=none header.from=niwa.co.nz; dkim=pass header.d=niwa.co.nz; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=niwa.onmicrosoft.com; s=selector1-niwa-onmicrosoft-com; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-SenderADCheck; bh=UOuctOLIOT1cArFooAups5qTzJ41jiZllrnA2olqVis=; b=S1ZbRh32YD0v+bZLwkKmHZG8WaGhU7T/F5FyNny9Z7rDpW/vBOdR9Su/ZZpfaksEvvldn+S+YmhbRetyO0dLXPgp9NIHdJhW3s9Yp2HQDQsq6uQEukuNiWu9HscIequD3gordSynFOJUa31ElfWC8z5tq1dNlmD8R97D+5B8x2M= Received: from SY4PR01MB7076.ausprd01.prod.outlook.com (2603:10c6:10:145::5) by ME3PR01MB7323.ausprd01.prod.outlook.com (2603:10c6:220:136::18) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.6954.21; Sat, 4 Nov 2023 21:42:34 +0000 Received: from SY4PR01MB7076.ausprd01.prod.outlook.com ([fe80::f5a2:bf0f:803:a6a4]) by SY4PR01MB7076.ausprd01.prod.outlook.com ([fe80::f5a2:bf0f:803:a6a4%4]) with mapi id 15.20.6954.025; Sat, 4 Nov 2023 21:42:34 +0000 From: Brent Wood To: "pgsql-general@lists.postgresql.org" Subject: Re: Postgres limitation in user management Thread-Topic: Postgres limitation in user management Thread-Index: AdoOHK35KtPRSOZXS1Sa5czpZ/jJmwBSc+uAAAAXtZQ= Date: Sat, 4 Nov 2023 21:42:34 +0000 Message-ID: References: <20231104213303.4mtgamfyo4v5i33e@hjp.at> In-Reply-To: <20231104213303.4mtgamfyo4v5i33e@hjp.at> Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: msip_labels: Authentication-Results-Original: dkim=none (message not signed) header.d=none;dmarc=none action=none header.from=niwa.co.nz; x-ms-traffictypediagnostic: SY4PR01MB7076:EE_|ME3PR01MB7323:EE_|SY4AUS01FT015:EE_|SY7PR01MB8574:EE_ X-MS-Office365-Filtering-Correlation-Id: bce5a12a-0ae0-4742-7370-08dbdd7ef611 x-niwa-seemail: Out X-MS-Exchange-SenderADCheck: 1 X-MS-Exchange-AntiSpam-Relay: 0 X-Microsoft-Antispam-Untrusted: BCL:0; X-Microsoft-Antispam-Message-Info-Original: g1r2lgPnqGpqjg3/sm/L6Y4u0ROrDu/tswrxDUimNBz6pBJtVqzXyUA4o43DaqyyvxfgpmJzbQDBs7XgetAHfCG+26IlZKe+gB823uZY3ieOhOI56y4QLAzrOaWuJuzk3y2Yw29b8KbU9UoJidWsgJd/Yv9hXIm0Ho8vH55s+kYhwvM5v8R+fkij7PJ+uEQOb3LMuxshMRe9Q5FhrTfY3Ykg9ybtgRf2rd9QDktXwDriJi7sClWTZnCGhQbeIg7AIYwy7OqnI78Yg1iii0wWFwzcD7Zsh63QnWyLqGI4qwVVsspIBPfNcM/27zgEn7gxVMvButV26TgKoe9o4eXhLm6VCVHNr6gD9VLMNDnSynXctjpwtYWAU6zmTT1qp06S76t6vdTz0Z4sCxfLdp8F9p09o9GzIsdQ3UVRbZj08nsHiICasp6nqEOo7srmhlDLB0Tj4GW0YOz+OUBTdW9y5YkGRbwjI2zcHyml8t3X5x+xDEzZV3a/W6ogb1Vm6w0P0SmqjHCVEsVjn5bn8uuraVcn5uRkCnIwIwCKm9GgP8iOxlio7DY4RsNMBy/NNdOf+MQ+PAhY8guTQWMHoN5SNxLqOb0vOyx9OEIAnVac3jk= X-Forefront-Antispam-Report-Untrusted: CIP:255.255.255.255;CTRY:;LANG:en;SCL:1;SRV:;IPV:NLI;SFV:NSPM;H:SY4PR01MB7076.ausprd01.prod.outlook.com;PTR:;CAT:NONE;SFS:(13230031)(136003)(366004)(346002)(376002)(396003)(39860400002)(230922051799003)(1800799009)(451199024)(1690799017)(64100799003)(186009)(66946007)(76116006)(64756008)(66476007)(122000001)(71200400001)(9686003)(45080400002)(53546011)(7696005)(6506007)(33656002)(478600001)(966005)(2906002)(83380400001)(1015004)(38100700002)(166002)(41300700001)(26005)(86362001)(66556008)(5660300002)(38070700009)(66446008)(8936002)(55016003)(52536014)(316002)(6916009)(19627405001)(8676002);DIR:OUT;SFP:1102; Content-Type: multipart/alternative; boundary="_000_SY4PR01MB7076F7F028CE147EC66F918DA1A4ASY4PR01MB7076ausp_" MIME-Version: 1.0 X-MS-Exchange-Transport-CrossTenantHeadersStamped: ME3PR01MB7323 X-EOPAttributedMessage: 0 X-MS-Exchange-SkipListedInternetSender: ip=[104.47.71.169];domain=AUS01-SY4-obe.outbound.protection.outlook.com X-MS-Exchange-ExternalOriginalInternetSender: ip=[104.47.71.169];domain=AUS01-SY4-obe.outbound.protection.outlook.com X-MS-Exchange-Transport-CrossTenantHeadersStripped: SY4AUS01FT015.eop-AUS01.prod.protection.outlook.com X-MS-PublicTrafficType: Email X-MS-Office365-Filtering-Correlation-Id-Prvs: deec17f3-742b-474d-f1cc-08dbdd7ef47d X-Microsoft-Antispam: BCL:0; X-Microsoft-Antispam-Message-Info: =?Windows-1252?Q?aGSe1ZB9gmysthpcoGIpP+BXSMU9NOVmwO4iKLvr01P6vMN5MFcjnPRA?= =?Windows-1252?Q?MnAatoxUdnmzwMhHmo3y9hMjTAVKCmSaWSLIiIn38tyTMnmXMYhFxN7f?= =?Windows-1252?Q?iBrK8Vlx+P5Ew8k8hPZpzBRnhsgza8VwZ2sCKQCa/gAuS4CtzNLVz6a2?= =?Windows-1252?Q?YDLMORumAbQVK6Xez1SA2JjsFntHq7H5Kk9YbyGgWJt5thKtk63lC0KG?= =?Windows-1252?Q?JA5i5iVovWMER64YGKQa0JHAx0zWksutcjejHBrunrIvnHtMg/9h1qEY?= =?Windows-1252?Q?m/zlBo3XKEvBbYucsVnPbtZKiEETuN2eDuLRHUZeKQFjUUfdF7Yl8o3X?= =?Windows-1252?Q?5iRP8CMN5O0GB/0WPMrjW2T8ya94noOkXd677zUtlY+cXCBq3866tBe8?= =?Windows-1252?Q?lVWlHPRguegPRDprDetU+qiAEi/Isx+dnSGeDvasCrbCNYFqb9tAF5E5?= =?Windows-1252?Q?r6Xec1M+wxW1cHuuIwsJ14BEbBgACWwzUyWHLssIGl1fUBa6EhQcwi5v?= =?Windows-1252?Q?sN07xRi9byVNPuwC7SRytT7kDo1n/xyiCSnQZ9yF6yRkd3/+ReCJUl8V?= =?Windows-1252?Q?7WMvQDLVTVZzKfvIDzLn7HqfIKyXcia07rNRS0YLl0xZZ8KC2GbRxaP9?= =?Windows-1252?Q?lV/eQD2ru4yYAaLcCJacDM2HsXOzbYPNvD3U7EvyRWxhbkPQQo/OPY49?= =?Windows-1252?Q?zQG53cYnMg6sOPnoofrDZLVerhvPbP+ek99A85+lD0lB//TgXuXc5yV4?= =?Windows-1252?Q?R27fF+IQjfPFj4F6qDuwMXCztkWsvzYrJN7xKRCuTwQgp0HjLra603Ei?= =?Windows-1252?Q?jdOe3n6KjhunrP+b2uooLf+tSYo/bOxNgDiPcGeB7ujI/YyvlOmFCVyJ?= =?Windows-1252?Q?bbP+yN+2WxLin/2aUsJSW/AnNLQ8Ge/p8Vbah9btvlS5/x9Tnu44A+bB?= =?Windows-1252?Q?1oKMj8rW4GIsootSGhtahbCNcYgzbNqfaOZp+PpcqXYwy8nbSSlpunln?= =?Windows-1252?Q?Db8I8zYvlMzzBEahwbqWd+PCQa2u6jdPDHZ52YUoT9QiSudH/Cs=3D?= X-Forefront-Antispam-Report: CIP:103.229.249.34;CTRY:AU;LANG:en;SCL:1;SRV:;IPV:NLI;SFV:NSPM;H:AUS01-SY4-obe.outbound.protection.outlook.com;PTR:mail-sy4aus01lp2169.outbound.protection.outlook.com;CAT:NONE;SFS:(13230031)(4636009)(396003)(346002)(39860400002)(376002)(136003)(230922051799003)(451199024)(7200799017)(1690799017)(82310400011)(1800799009)(64100799003)(186009)(40470700004)(36840700001)(46966006)(40460700003)(40480700001)(55016003)(26005)(7696005)(336012)(47076005)(6506007)(53546011)(9686003)(156005)(966005)(83380400001)(5660300002)(41300700001)(8936002)(8676002)(52536014)(1015004)(2906002)(45080400002)(478600001)(32850700003)(6916009)(316002)(70206006)(70586007)(86362001)(33656002)(7636003)(166002)(82740400003)(19627405001)(36860700001)(8400799017);DIR:OUT;SFP:1102; X-OriginatorOrg: niwa.co.nz X-MS-Exchange-CrossTenant-OriginalArrivalTime: 04 Nov 2023 21:42:36.6076 (UTC) X-MS-Exchange-CrossTenant-Network-Message-Id: bce5a12a-0ae0-4742-7370-08dbdd7ef611 X-MS-Exchange-CrossTenant-Id: 41caed73-6a0c-468a-ba49-9ff6aafd1c77 X-MS-Exchange-CrossTenant-OriginalAttributedTenantConnectingIp: TenantId=41caed73-6a0c-468a-ba49-9ff6aafd1c77;Ip=[103.229.249.34];Helo=[hamlmail.dmz.niwa.co.nz] X-MS-Exchange-CrossTenant-AuthSource: SY4AUS01FT015.eop-AUS01.prod.protection.outlook.com X-MS-Exchange-CrossTenant-AuthAs: Anonymous X-MS-Exchange-CrossTenant-FromEntityHeader: HybridOnPrem X-MS-Exchange-Transport-CrossTenantHeadersStamped: SY7PR01MB8574 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --_000_SY4PR01MB7076F7F028CE147EC66F918DA1A4ASY4PR01MB7076ausp_ Content-Type: text/plain; charset="Windows-1252" Content-Transfer-Encoding: quoted-printable >> We have 2 sets of database user groups =96 >> >> 1. App =96 who owns the application schemas (and tables) >> 2. Support =96 who provides db support >> >> We want Support users to have no SELECT or DML privilege but only ALTER = TABLE >> to perform any troubleshooting in the database. >This seems strange to me. What kind of troubleshooting requires to >ability to ALTER TABLE but not to do DML? Where your db admin & data admin are separated. Data security issues can re= quire minimal access to data, which a dba does not necessarily require. Esp= ecially when the DBA role is contracted out. Sort of along this line, we have offloaded user management to AD, so our DB= user management is now carried out via in-house IT, who are not DBA's and = have no access to data. Brent Wood Principal Technician, Fisheries NIWA DDI: +64 (4) 3860529 ________________________________ From: Peter J. Holzer Sent: Sunday, November 05, 2023 10:33 To: pgsql-general@lists.postgresql.org Subject: Re: Postgres limitation in user management On 2023-11-03 06:26:21 +0000, Kar, Swapnil (TR Technology) wrote: > We have 2 sets of database user groups =96 > > 1. App =96 who owns the application schemas (and tables) > 2. Support =96 who provides db support > > We want Support users to have no SELECT or DML privilege but only ALTER T= ABLE > to perform any troubleshooting in the database. This seems strange to me. What kind of troubleshooting requires to ability to ALTER TABLE but not to do DML? hp -- _ | Peter J. Holzer | Story must make more sense than reality. |_|_) | | | | | hjp@hjp.at | -- Charles Stross, "Creative writing __/ | http://www.hjp.at/ | challenge!" [https://www.niwa.co.nz/static/niwa-2018-horizontal-180.png] Brent Wood Principal Technician - GIS and Spatial Data Management Programme Leader - Environmental Information Delivery +64-4-386-0529 National Institute of Water & Atmospheric Research Ltd (NIWA) 301 Evans Bay Parade Hataitai Wellington New Zealand Connect with NIWA: niwa.co.nz Facebook LinkedIn Twitte= r Instagram YouTube To ensure compliance with legal requirements and to maintain cyber security= standards, NIWA's IT systems are subject to ongoing monitoring, activity l= ogging and auditing. This monitoring and auditing service may be provided b= y third parties. Such third parties can access information transmitted to, = processed by and stored on NIWA's IT systems. Note: This email is intended solely for the use of the addressee and may co= ntain information that is confidential or subject to legal professional pri= vilege. If you receive this email in error please immediately notify the se= nder and delete the email. --_000_SY4PR01MB7076F7F028CE147EC66F918DA1A4ASY4PR01MB7076ausp_ Content-Type: text/html; charset="Windows-1252" Content-Transfer-Encoding: quoted-printable
>> We have 2 sets of database user groups =96
>>
>>  1. App =96 who owns the application schemas (and tables= )
>>  2. Support =96 who provides db support
>>
>> We want Support users to have no SELECT or DML privilege but = only ALTER TABLE
>> to perform any troubleshooting in the database.

>This seems strange to me. What kind of troubleshooting requires to=
>ability to ALTER TABLE but not to do DML?

Where your db admin & data admin are separated. Data security issues ca= n require minimal access to data, which a dba does not necessarily require.= Especially when the DBA role is contracted out. 

Sort of along this line, we have offloaded user management to AD, so our DB= user management is now carried out via in-house IT, who are not DBA's and = have no access to data.

Brent Wood

Principal Technician, Fisheries
NIWA
DDI:  +64 (4) 3860529


From: Peter J. Holzer
Sent: Sunday, November 05, 2023 10:33
To: pgsql-general@lists.postgresql.org
Subject: Re: Postgres limitation in user management

On 2023-11-03 06:26:21 +0000, Kar, = Swapnil (TR Technology) wrote:
> We have 2 sets of data= base user groups =96
>
>  1. App =96 who owns the application schemas (and tables)
>  2. Support =96 who provides db support
>
> We want Support users to have no SELECT or DML privilege but only ALTE= R TABLE
> to perform any troubleshooting in the database.

This seems strange to me. What kind of troubleshooting requires to
ability to ALTER TABLE but not to do DML?


        hp

--
   _  | Peter J. Holzer    | Story must make = more sense than reality.
|_|_) |           &n= bsp;        |
| |   | hjp@hjp.at        = ; |    -- Charles Stross, "Creative writing
__/   | http://www.hjp.at/ |       challenge!&quo= t;
Brent Wood
Principal Technician - GIS and Spatial Data Managem= ent
Programme Leader - Environmental Information Delive= ry
+64-4-386-0529

National Institute of Water & Atmospheric Research Ltd (NIWA)
301 Evans Bay Parade Hataitai Wellington New Zealand
Connect with NIWA: niwa.co.nz= Facebook LinkedIn= Twitter Instagram YouTube
To ensure compliance with legal requirement= s and to maintain cyber security standards, NIWA's IT systems are subject t= o ongoing monitoring, activity logging and auditing. This monitoring and au= diting service may be provided by third parties. Such third parties can access information transmitted to, process= ed by and stored on NIWA's IT systems.
Note: This email is intended solely for the use of the addressee and may co= ntain information that is confidential or subject to legal professional pri= vilege. If you receive this email in error please immediately notify the se= nder and delete the email.
--_000_SY4PR01MB7076F7F028CE147EC66F918DA1A4ASY4PR01MB7076ausp_--