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 1u7kQj-005Jgz-JP for pgadmin-support@arkaria.postgresql.org; Thu, 24 Apr 2025 00:27:06 +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 1u7kQh-00BdHs-Ru for pgadmin-support@arkaria.postgresql.org; Thu, 24 Apr 2025 00:27:04 +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 1u7kQh-00BdHk-56 for pgadmin-support@lists.postgresql.org; Thu, 24 Apr 2025 00:27:04 +0000 Received: from sonic312-22.consmr.mail.bf2.yahoo.com ([74.6.128.84]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1u7kQf-001cff-14 for pgadmin-support@lists.postgresql.org; Thu, 24 Apr 2025 00:27:03 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1745454419; bh=q3tUJ6Meyo5DqJJnIsEtogF3dQSsq0ALCQXh3FSjeK4=; h=Date:From:To:Subject:References:From:Subject:Reply-To; b=msxG79cpGOVAgHcLRjUD/vr9m6mguFgiZYTXLDd5PIJTxwwUJs8WhRK2SKGmM/TgPBur0lAGlTyOGvN2Xldu2KAfKqR3mbeGZE7n0I9UM/MKEAXR1GWb8g6CdKRB6C1TDd9Ci+H6f4apJa/G48i94n47qsXSBiH6fEoGDWJFlhlK8sJN5gUBlYB6KQnfh7hqKQAZ3818ovjjAB0EXLKVp0p7hiSCBq/RYaWKJoRlv/aDe5tb0Z/Sig4KxXBwOjRE6JblCVBIilwSjXM6KKq54fSTDAipsp8avQTsUtUHlTGWRu+bAAapt4F6k+NSwphDdkZN/v4ex3tlSKIMjOx3Qw== X-SONIC-DKIM-SIGN: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1745454419; bh=oDBj7pePT6Ur2muVm3isFtY4+HrV+P4bpVSmFQvzKiN=; h=X-Sonic-MF:Date:From:To:Subject:From:Subject; b=WNNbsmNfJc2v+6XFVz/qPgmIb6t/XmCqyvSRXAQXPxpYLa4QoCJ3lIUNTQKYz6/3JtBhCoo8H2Ft4DdrTBVyIM5uy8ywqEVAwK0EidAMs+JPeY5TVkmEKvqRiepxI5d35kIeg3ZBgY+rKemRpCr3slr61QyLl4b8MdnurYR5WwkxOpQvxW1hNQTyKzSaPggZ4YVbwoLToSsGiK/eMI4vY2IJXKEO4Se32UKlnUUlloJzHiuV42fwdw4+lXKR8bOuRAvJg6DpMtBao09bvlmh21dJ9uo2X7M5OVLCX9/d863k8WDp4KrtA/WYtavTcFwxN3uB8o4Mw54cnc3ygHB5BQ== X-YMail-OSG: vCrTM00VM1nkMIC3FZcrO_yyJcWd4NQmfJaa9EG71uG64Tj4yy0HtPVqVREJPCN FZ8wuNZKblNNPR9gXmG_l.zbODaKAP380mwlkbgnCydDLlgKNzlSBOcmBmRCzuIS5tZHyXe7JjLr v.eeJKyWKQMR9S7LCllydlddMsly5TNnxQgXcGTMWhwPBWEiro7WmcFRMjriwpa4OsvV2QcDGeJs 2DhGUBaDFG5_7.sT5Zwg4Gi4hPkWfBJjjm_oi9xdydXtMvF5BTp1U4Rk_WgQ7T7VJgXGnse4A0tQ tSsyuVHs6Q4QE0OFy_SWW47XhGAGw1m3R.XkSFDjRb6TIRQZnyMqboAKkdxeIaAD6lSSW1sDTXav NW7xAXOusREGDJhKtuHYvf7_wPbXSzdWhKCPP2ZcTjMxSGRZ8ZD4tflTQaTmYR2li_bmBGyVZ3A5 IX9K713B6PfJEa.K4q7cXgiK3cKszzc2FbLRhBed20tp76Qzulz8V.TIfp97CpOdP.1mWf_r1FEt e4wWh6BIxGCvZ9N0CizsMk9nckvntLjNO5fqMo9pjOADKkwktvQKV.mhSqxJide1vZg310FIGocB JVUtkHqD6uP7yy6O9Z6RlA2j7qLTFSgbDqCrrbW9SXOCWHPIhMZkFZce8dkiQEP61X5XuFD8fHap iAA7CizMqyt2t_ykM4QNdj8DghC4bLLOME8ubu99CREdOpRneEgo0WLjotvf6Vtd_MRuSh4_Z6mD yRsjgTL91.TcQpZOwcRxxvfjvu6Q7QGqqJAJfCPEm4C5EpcYgTw0JoNL9E8EzqAJuw651kZSGbbV Ak2O8_1fPcUgnAW8ikElxqxxoj6u5IRp7SrTpsrzkIalnpT6Mf2Fq.x6gE9XFfo4cqLq.Ly2a4zv Iue2eWr57GvDaVVhGPeXYCWzRDEzT2ZGNs54PX4G2KNU07eSIqbXGn5aRc85GiYSxZ_n27OguiHM JRJjbOXHBpG53YFim1xSv1YrnIQBekHhfO7KrbbTiFtJVBOu45I.bBPHs9NWTPJPTTDIS78Kdehc CzIp_mdS4TnNdeqL0bKrqNRgnTHNR2L9HUhJTy.be0TdpT.aTVPhPZa7dY_0RbMm8vo7nRU2a7F9 fNqbxhLj9ZlniG9FVphZiUc9vg8kseJHuEmKMNCcETNWNuSvIFsp6d6.yOJImXtxZb3amso3JdJ8 mpk282ialvguYpNo._lNU.pNPcBgjLUQfdVaN1mCIUy5JAK5Kj61WYBzgim2ioPthFyIpIuFKyUN a1ecaQZ847RQ1Gbfsxj41yoPueeWgMqV_KRhEktYpN0FV51wm357cuuODNhSojzyzAJM9LQuFLSl H813br9GOcxzyhv8wNDoGB71BqAz2Eebo29qEt_rjLFoxfwaOpLduxx4lhFy3AjRxvzZLr7WRTvZ fUE5Lv072t9ZNQEi9Nq.eAzTde6Y8fEcNT_K5MqJoRsXM4N7PPNd0qzVbu1qLg9woUoljI16Pfv9 btjpEIkscVODfh9DjGPStdmPO2FkWDZUUjhx3wAWShPzjiMuoKrc38AyG23yquEVpUH07a_wPMJ2 g5OFKF08obpG3MtSqWnSwI5sWkhStG1oSW2Hx8D_pb_UyVvddtgZvnA68NxPT71F2XTIJIktBy1J KffHQWBfSf_QX8Z1YReCF7TF1rpFQJeQcKCpNQ3cn4fbzYCo1t8nVH0GAAIVBRBbrY.OS3SIBvGF ucVfEkRo_3u0Szid7cCeNouLNPqoztMVCT0V7t3Hek2IlgXf2W2BneEzVyKr6cEqhXdD08znaKDf 2m7NGlxqu4nC7gUGB7JFWsQO4048m6vPPqzCL.juLim1o9FgPfyn8_13ozaQ4Y7rqWgSulV0zvrP JoTZVf0z4atKDeB2ON5LUyr.aJR6DFXyU6InHHfLo5CAA_In.82yamYiEfJpYCD_ZsFjmofLe5Wo OIbGcI68Jf1j8dvx6MdpQfGtmRK.rZ7BPlzRavQLNo96e_25JLvEt3Djtf2oy10pGarXYiNzKKeb 72jZrymLOFpWK5Lxmwsm4cLyCarQl1wuuDcIvs789yWA2H3QO8nApfMVL84n9DMLG0JLmVq0amGP aXFx9esMTsdIpLBUrCQ_EAKpQwXf6IkK5U2o8lMpGgzp1edLpS_vMVDHiwpXoAggYIj9XSbAnt2H g02Jzbh2JW_LcWM4Qt1A1X7KogUQsDjgnyuKdO9jyMnyQ3EsPy4aGI6nUt9s- X-Sonic-MF: X-Sonic-ID: f0466823-713e-4d94-8a41-cb43d6e03342 Received: from sonic.gate.mail.ne1.yahoo.com by sonic312.consmr.mail.bf2.yahoo.com with HTTP; Thu, 24 Apr 2025 00:26:59 +0000 Date: Thu, 24 Apr 2025 00:26:58 +0000 (UTC) From: =?UTF-8?B?w4Yg4oCi?= To: "pgadmin-support@lists.postgresql.org" Message-ID: <2094241112.614816.1745454418891@mail.yahoo.com> Subject: Assign Role based on Table Cell value MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_614815_1538735300.1745454418890" References: <2094241112.614816.1745454418891.ref@mail.yahoo.com> X-Mailer: WebService/1.1.23737 YMailNorrin Content-Length: 1480 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk ------=_Part_614815_1538735300.1745454418890 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 7bit I have several users accessing PostgreSQL database managed through pgAdmin. The database consists of a table with several columns and rows. I want to grant permission to certain users to write/edit certain certain rows based on the value of a certain cell i.e., if cell value = x than user 123 has edit rights. From what I have understood, the Grant Wizard grants access to the entire table. Is there anyway be more granular in granting access/assigning roles?Thanks ------=_Part_614815_1538735300.1745454418890 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: 7bit
I have several users accessing PostgreSQL database managed through pgAdmin. The database consists of a table with several columns and rows. I want to grant permission to certain users to write/edit certain certain rows based on the value of a certain cell i.e., if cell value = x than user 123 has edit rights. From what I have understood, the Grant Wizard grants access to the entire table. Is there anyway be more granular in granting access/assigning roles?
Thanks
------=_Part_614815_1538735300.1745454418890--