Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1lJPKb-0003Ti-7P for pgsql-performance@arkaria.postgresql.org; Mon, 08 Mar 2021 23:30:33 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1lJPKZ-0007Ju-OL for pgsql-performance@arkaria.postgresql.org; Mon, 08 Mar 2021 23:30:31 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1lJPKY-0007Ji-JX for pgsql-performance@lists.postgresql.org; Mon, 08 Mar 2021 23:30:31 +0000 Received: from sonic303-22.consmr.mail.ne1.yahoo.com ([66.163.188.148]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1lJPKV-00024L-7O for pgsql-performance@lists.postgresql.org; Mon, 08 Mar 2021 23:30:29 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1615246225; bh=3MElNj3vpSf7L9+NsZ67fgf3fAaQr0HhXU+93L5r3ag=; h=Date:From:To:Subject:References:From:Subject:Reply-To; b=meRXtUOQhqh3+PmFCWvd8T+9HwO/6DgFeTJonMHEGVDinXRbDoEkgUxmCYfwJC9tSJ6fzuBzFXDneimmJPERsH6074iaIuKt/7bmUX9ik0NIraLMRJByJ86veQQTkq1IiPAlWlfAwNOTTXIBQLMQbI4pkAFnCp+yCQP7U7rIbuNCin9VlLsDf54hXveogzMHjfsqoiq8igX6B9f9Gh7ViQsP2iV2f/LNrKv+9kfX7MxSSLAs7ZPFR1JjIEibZK6Nc9DWSaPcf5yke6jmu4szKRovrXNd2yABQkbvXyJ2GvnbnXPSwsZMVhvDJz0ecvvKMP4PmYow4+4k/qL2aULreg== X-SONIC-DKIM-SIGN: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1615246225; bh=wBeP7MDouacYDWSKJhaepD7UcA+xaL8iD6hgrkXeqeO=; h=X-Sonic-MF:Date:From:To:Subject:From:Subject; b=IhAXQR/BV6CRqRz/gnU7gDqkweyOfAL1t2Rq6MEK6TaHW3BinwzOE1zeO22SLNbfsVsXGBhfd9DCUnfollOmmMfJg4dJcjANpenCcj7cmggfO89wyNVmsULPsYgWIJ0vFq4DQKFK2QiRx0qxeu7n9Q7lM/RO6ozxknnNHLTVCRUAVXvbSefP8ZQg/z9to/q5yumR5RRVF9ke2ZFFvixX0tk1RMObfe/xEtkcNE/p4PCY4iLh6GJjQBUumfBYirTjlqUL70CJ+UDJsxe16lK1mU+DAIIznsDj186rizpWQz6CDczzi7fKaMHeUGvgQ2L3/NlC8PtuRB4KZ9iVvyUrfg== X-YMail-OSG: NskgPBcVM1mwJAv3nqe3kvJQCy7H1W0OJbfwBAzQ2Jk1oN8Bv5qMLRxma12ta7n .ydUR1ew0AoP.dJh5LBXuc5JD1k48o4A_rbrcQ2sIvykkifI.fN3w.B1sD3iLSI_4f382Yye0ic3 PGB.Arf5pmwbweN.NpGs130NXe71kF9w3GElVeFEvDGJQahm7ye2ui7sLpdZzO5KPt00bgv2vIzL a4Lf9kt0_fWIfrjKsdM8yVaK8BMoD21cqE4AH7_KqMeOg7hnoZJE9KELlM2nGdK.rANWwZAD7ITK HP2dQjDAgKVwYxsxTKEvqengJxup3l7R98bINSJLlAIhX0Buky2lu5VrSotFmnX6MOQaaFxP4VFF GxrVipm7Sv2oAeQ7v.zTg4kyAn4YIQ5.DHLGFvUJr16VWltYJNaRNp8BjW3jdxjTLcsB5fD.Qm63 F6YY6i5CLfIAf92wHOgiCUL0CRMnoa2MBs7etAT2XBvuPu5vRgQpE4miCakRiXVrDpQ_ibDVSTdJ ihF.KlYrzzCJ0RD5C8BNBTstlF1s98GQkHGQON0NRZFVmFw3MO9tPO_vFrQ.ccWKR4yj6vshrb8I BgMHv4t3YbFg8L0xjbu3ArRjg_Z6kIja4Y9z6ZG6szred5ESXM7I5KGVKCkTw7KNNabXu9t_cafB .57XfYZSHI3rxCqCAt0zZrxaUFPKWZLTjgggMW90qHzQe_lu.sH0jgc54Pb3joC62RXXOgWVSdfD Udp7BezhdrZ70neCWWwKb5glZz3byoV_QxAAQKuG.kCDGWMr81gtgUPya38VmJpVggy3CIUuiEAm Ntd.yrMmJ3X7DckIp4iTumoF2Np1.uO8IaHisaRg5RXdL6TYSqcGpzE7gG58Bq3AKCU0qKgKbiCf IwlN0WxmlCWo3eQFR.sxhBhJR3nUtoM1ChFt_tY6w3ueq8RF4spkiJAGTQwNR0gRq0LmhsNzyjk1 a7cbUdcGojKNajElK67z2Shcobds4Pr3pOsxfR3vNpGM4Hy5NAkcj2zaMNwLKXa6IO4CrErQdkR2 vjc0C3DIenXGtSh0rBqG26nstHaQTMopp3zk53T4oWJIzL64DDluHoixnJKzLL8_wuDeTuVoP8_5 mvlzd.k2Y7DOlJofm5b4Ctdq_a30OmT13WzYrMWb4lq6DGUaXnYIyxHDTPqPGxctMQFQPAGRCCYL 643FrazYz3g0tbutnZuaB3yMnBSBF2csdmcccata_zvN11Ar1ivaxzrVvUZ3sAtUU99FXo9VND1k bnH032b4eo_oGDuCoJtlkzO2H5.mi9CZ.6LzcApKNfdmQqeLHnlUo.6shVVdbxTYIYqUUR5UUdWM V2A4v3MoptK1nugk.vJYyUXCUcY_.zT13uuogbxC8DeINg0NgMczEj4T2fnuqLregE.XHBzUrnW6 E3X2yennFtbak3q4OI3A_EAmiDHJ9NEI1nPx75MI5TJ21u6FS_LPsJjgT9W9kzmWIR5c6d4hGjrN JPaTlLRxaJ7.pYusczk6gikYvpvrwQfWQzzAtdtaTeHMiU.9abpbw2uVEjS2uWT7j4LoZSiqUvat 1tfiMBvawha77sH_PmHNvvfANebn9dA95NzO9hhAKF27HGm7qyKM52i8BgmKyY1yAQkirpXg8t_C iY8ik0atlr_RumBFkpNb1sH.BkdepReZfC_PIfMzNwg6fPaqS_GRHo3kSqQaxLIS.140zxSVDBll 2pP0Dlz.jnZ3DyEoP3bHYtUkblsMkb4HyPzmHB8XG.wbAibfEmn.VR1M3vU01iEigaZtNcj_9rQN PGawSVzuVoPsTTHVVMVhlphoBE_RH0DXQmuLyENnlE4yPF240C2V0ahei073upXiImlX1zQEL3MI VKH_or.OP8oOjSzBDJRzWTRhF8QcIE_qRMTelDrrJoaVQ51kzUNwZGfmwoi8KLAaDkiMIgZQZWZF jkWt3Hygi7a08RgPZnN9AvoX76Juo8cGS5f0ZRCFcqh6YkzdUtRyBOI8eRUww3yhiKZdwl53PXRc 6Btyldtt83uZIGbLCAsoARpecDQWqBUflmJNvzWg_oFXrBFFPP3kj896mIfTyQVFY3TaVu7WjQCu agtmXGgsvPKxxg3Wmf3jX1BvSqZjZHjJ8kmFSEtnUXblgagipsZIBRR1cfKk8bL_ck4Wmxwg.B25 EphuyqBYGBkZ44pVhi5AfUxChRGJw8_aMVciLH4EKGbg4FWacjER7RzbQjJpOLDj6e5OYvrlfTkh XDRjThuX_jyZ2hDJ6_Yjk.PvEAZ2fvFnF8Ytj3xuCUcVhIDzApRKdperVZ8ZQ2rRjIsNayXyQb8f Bp1xnys1C6rDLGPuGYNkFxttPTSJz2IfyONUa27W2YriX_qAJ2XkuzBWO3kTCzf3MJvnPni4nU7j 60PnGXJWEDvGTeufKUBwrEQNyO6Fsfqa3l3WPjFOzETMaa1yTxtNTxboiY3P1Uiv3Ay_h_rg0qr2 hB_zkfeC6l9BMoEo7V6ly6wibOu0Sp_r847HZvgsmNFPdk1b5UWlKLI4tWtC2vTD4RbwQWuep0WL otgf_7.spol7K9oKBrw-- X-Sonic-MF: Received: from sonic.gate.mail.ne1.yahoo.com by sonic303.consmr.mail.ne1.yahoo.com with HTTP; Mon, 8 Mar 2021 23:30:25 +0000 Date: Mon, 8 Mar 2021 23:30:14 +0000 (UTC) From: Nagaraj Raj To: Pgsql Performance Message-ID: <1851347365.1459375.1615246214890@mail.yahoo.com> Subject: Users grants with setting options MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_1459374_2097019760.1615246214888" References: <1851347365.1459375.1615246214890.ref@mail.yahoo.com> X-Mailer: WebService/1.1.17872 YMailNorrin Mozilla/5.0 (Macintosh; Intel Mac OS X 11_2_2) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/88.0.4324.192 Safari/537.36 Content-Length: 3421 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk ------=_Part_1459374_2097019760.1615246214888 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Hi, I have a quick question, does role custom parameters settings will be grant= ed to users well?=C2=A0 Does user c_role will have the same settings m_role.CREATE ROLE m_role ;CRE= ATE ROLE c_role ;ALTER ROLE=C2=A0m_role=C2=A0 SET configuration_parameter T= O 'VALUE';GRANT m_role TO c_role; ------=_Part_1459374_2097019760.1615246214888 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
Hi,


I have a quick question, does role custom parame= ters settings will be granted to users well? 

Does u= ser c_role will have the same settings m_role.
CREATE ROLE m_role ;
CREATE ROLE c_role ;
ALTER ROLE m_role  SET configuration_parameter TO 'VALUE';GRANT m_role TO c_role;=
------=_Part_1459374_2097019760.1615246214888--