Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1aJd8O-0004Va-5C for pgadmin-hackers@arkaria.postgresql.org; Thu, 14 Jan 2016 08:19:56 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84) (envelope-from ) id 1aJd8M-0002fP-I4 for pgadmin-hackers@arkaria.postgresql.org; Thu, 14 Jan 2016 08:19:54 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84) (envelope-from ) id 1aJd8L-0002fF-Ms for pgadmin-hackers@postgresql.org; Thu, 14 Jan 2016 08:19:54 +0000 Received: from mail-pa0-x234.google.com ([2607:f8b0:400e:c03::234]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.84) (envelope-from ) id 1aJd8I-0002es-CB for pgadmin-hackers@postgresql.org; Thu, 14 Jan 2016 08:19:52 +0000 Received: by mail-pa0-x234.google.com with SMTP id uo6so357509527pac.1 for ; Thu, 14 Jan 2016 00:19:49 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=enterprisedb-com.20150623.gappssmtp.com; s=20150623; h=subject:to:references:from:message-id:date:user-agent:mime-version :in-reply-to:content-type; bh=JGYFhEU9bNLdi3x4aiWC5K236v4qKfmcjjf2RmECaqg=; b=Vd2md7790M5nI+JAT/lM58YkQQ0Qfeem4OStEpN0rqjucxH6+yxijpQSunBz+WNOWX ah3R/RgBElK6ZLQcomc2idrwNUPAGLIeaZ8p48/RaANAN6bdZiJwZJRKM1bS6podexDR x8+06/hsdFBFDqOT8fNrsnRpfi6T34oqa1d7PjJe0pTvhXEOERK8EVx2B2B3jINCGwEl ohqTKwqow7uGclynJjJ/RBkeUYTUN5yswGT4WubCMukzoRZOGeuazQCxVPqP+O7jDtGi Yv8IbRCjftCU7dthj1Am7nFohiYjWUu2m4HjOukYtay4Ud43iNKN+0FgDGQWWXz+5bXB TS+g== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20130820; h=x-gm-message-state:subject:to:references:from:message-id:date :user-agent:mime-version:in-reply-to:content-type; bh=JGYFhEU9bNLdi3x4aiWC5K236v4qKfmcjjf2RmECaqg=; b=PPMAiHkn/gMT/cRJ6Gfc8fPFT8iRYIONNICLGGVrHBw0YVWbBLzg9kZLT1fUwWrazS S9bzkysPscDfrVlXPLst9wJXSVBqR7bRcS176I+6okezZa0BDxln3VzOByrZr9IS3ecy sUrQvuM49dm7kJXBsVZDeVtHP/tIjt5CMA6JaAeRpjXY+iDkdorfoR+THl74Gj8gwugn Tl3Ngf1FgY7PIK95zsAwHKMfeI3DO9O4AJYeAbuBmb2ShBIB2CdUGWEPccu6I2NpRUAl fA5svQOLL/bVNO+Q8c3QSHjJtvujsAtAop1mzLNoj//+bPkxte9S+RE7JgX6zsZn9Ff/ notg== X-Gm-Message-State: ALoCoQlsHOCY0uEHxZlRIf/ZtUjmctwDIm2vYjTKrmHlL6X5RGMyyuPCTxIElpXmlfFo+4dCX0Vl5/cIwuSUS6gwx90Qj4dgcQ== X-Received: by 10.66.100.198 with SMTP id fa6mr3990068pab.123.1452759588935; Thu, 14 Jan 2016 00:19:48 -0800 (PST) Received: from [172.24.35.244] ([59.162.78.200]) by smtp.gmail.com with ESMTPSA id k74sm7439547pfb.30.2016.01.14.00.19.46 (version=TLSv1/SSLv3 cipher=OTHER); Thu, 14 Jan 2016 00:19:48 -0800 (PST) Subject: Re: PATCH: Login/Group Role Node To: Ashesh Vashi , pgadmin-hackers , Akshay Joshi References: From: Murtuza Zabuawala Message-ID: <569759C0.90009@enterprisedb.com> Date: Thu, 14 Jan 2016 13:48:08 +0530 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:38.0) Gecko/20100101 Thunderbird/38.5.0 MIME-Version: 1.0 In-Reply-To: Content-Type: multipart/alternative; boundary="------------060004090201080309060309" X-Pg-Spam-Score: -2.6 (--) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgadmin-hackers Precedence: bulk Sender: pgadmin-hackers-owner@postgresql.org This is a multi-part message in MIME format. --------------060004090201080309060309 Content-Type: text/plain; charset=windows-1252; format=flowed Content-Transfer-Encoding: 7bit Hi Ashesh, Observed so far, In pgAdmin4, 1) We are not displaying below items in properties when compare to pgAdmin3 - Account expires - Member of 2) Seems life one of menu item missing when right click on role - Reassign/ Drop owned 3) Security label is disabled by default, Even though security label is disabled, we get precondition error from server saying. /|"errormsg": "Security Label must be passed as an array of JSON object in the following.."|/ Causing: - When we add variables in Security tab on existing role, Sql does not gets generated in sql tab. - When we add roles role membership on existing role, Sql does not gets generated in sql tab and it also allow us to enter invalid role which does not exists. Regards, Murtuza On Tuesday 12 January 2016 10:47 PM, Ashesh Vashi wrote: > Hi Team, > > Please find the patch for Login/Group Role(s). > > Akshay/Murtuza, > > Can you please review it? > > -- > > Thanks & Regards, > > Ashesh Vashi > EnterpriseDB INDIA: Enterprise PostgreSQL Company > > > > /http://www.linkedin.com/in/asheshvashi/ > --------------060004090201080309060309 Content-Type: text/html; charset=windows-1252 Content-Transfer-Encoding: 8bit Hi Ashesh,

Observed so far,

In pgAdmin4,
1) We are not displaying below items in properties when compare to pgAdmin3
- Account expires
- Member of

2) Seems life one of menu item missing when right click on role
- Reassign/ Drop owned

3) Security label is disabled by default, Even though security label is disabled, we get precondition error from server saying.
"errormsg": "Security Label must be passed as an array of JSON object in the following.."

Causing:
- When we add variables in Security tab on existing role, Sql does not gets generated in sql tab.
- When we add roles role membership on existing role,  Sql does not gets generated in sql tab and it also allow us to enter invalid role which does not exists.


Regards,
Murtuza

On Tuesday 12 January 2016 10:47 PM, Ashesh Vashi wrote:
Hi Team,

Please find the patch for Login/Group Role(s).

Akshay/Murtuza,

Can you please review it?

--

Thanks & Regards,

Ashesh Vashi
EnterpriseDB INDIA: Enterprise PostgreSQL Company


http://www.linkedin.com/in/asheshvashi


--------------060004090201080309060309--