From: | Harshal Dhumal <harshal(dot)dhumal(at)enterprisedb(dot)com> |
---|---|
To: | Ashesh Vashi <ashesh(dot)vashi(at)enterprisedb(dot)com> |
Cc: | pgadmin-hackers <pgadmin-hackers(at)postgresql(dot)org> |
Subject: | Re: New macros for sequence node [pgadmin4] |
Date: | 2016-02-10 14:00:52 |
Message-ID: | CAFiP3vys+X=7sJkzWWqLpWe25Pdp1LYXfH=P58L1SZVNH8PL9A@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-hackers |
+ Usage of macros
Way to use in template:
*1] Security labels:*
SECLABLE.SET(conn, object_type, object_name, provider, security_label,
object.schema)
SECLABLE.UNSET(conn, object_type, object_name, provider, object.schema)
*2] Privileges:*
PRIVILEGE.SET(conn, object_type, grantee, object_name,
privileges_without_grant, privileges_with_grant,
object.schema)
PRIVILEGE.UNSETALL(conn, object_type, grantee, object_name, schema)
privileges_without_grant = comma separated string of privileges.
privileges_with_grant = comma separated string of privileges.
--
*Harshal Dhumal*
*Software Engineer *
EenterpriseDB <http://www.enterprisedb.com>
On Wed, Feb 10, 2016 at 6:57 PM, Harshal Dhumal <
harshal(dot)dhumal(at)enterprisedb(dot)com> wrote:
> Hi,
>
> PFA patch for schema macros for security and privilege.
>
> Now I have moved macros related to schema and its child object under
> schemas/templates/macros/schemas folder
>
>
> --
> *Harshal Dhumal*
> *Software Engineer *
>
>
>
> EenterpriseDB <http://www.enterprisedb.com>
>
> On Wed, Feb 10, 2016 at 5:41 PM, Harshal Dhumal <
> harshal(dot)dhumal(at)enterprisedb(dot)com> wrote:
>
>> Hi,
>>
>> Here is updated patch for macros. I have added required validation in
>> macros.
>>
>>
>> --
>> *Harshal Dhumal*
>> *Software Engineer *
>>
>>
>>
>> EenterpriseDB <http://www.enterprisedb.com>
>>
>> On Wed, Feb 10, 2016 at 1:06 PM, Ashesh Vashi <
>> ashesh(dot)vashi(at)enterprisedb(dot)com> wrote:
>>
>>> On Tue, Feb 9, 2016 at 3:48 PM, Harshal Dhumal <
>>> harshal(dot)dhumal(at)enterprisedb(dot)com> wrote:
>>>
>>>> Hi,
>>>>
>>>> PFA of macros (privilege, security) for sequence node.
>>>>
>>>> Also fixed minor issue in security macro (removed unwanted qtIdent for
>>>> provider)
>>>>
>>> This is not allowed.
>>> We can't pass on the data coming from the client blindly to the server.
>>> It is an area, which can introduce the SQL injection in our code.
>>>
>>> Hence - I can't allowed that.
>>>
>>> --
>>>
>>> Thanks & Regards,
>>>
>>> Ashesh Vashi
>>> EnterpriseDB INDIA: Enterprise PostgreSQL Company
>>> <http://www.enterprisedb.com/>
>>>
>>>
>>> *http://www.linkedin.com/in/asheshvashi*
>>> <http://www.linkedin.com/in/asheshvashi>
>>>
>>>>
>>>>
>>>>
>>>> --
>>>> *Harshal Dhumal*
>>>> *Software Engineer *
>>>>
>>>>
>>>>
>>>> EenterpriseDB <http://www.enterprisedb.com>
>>>>
>>>>
>>>> --
>>>> Sent via pgadmin-hackers mailing list (pgadmin-hackers(at)postgresql(dot)org)
>>>> To make changes to your subscription:
>>>> http://www.postgresql.org/mailpref/pgadmin-hackers
>>>>
>>>>
>>>
>>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Susan Douglas | 2016-02-10 14:01:41 | Re: Backup and Restore dialog documentation updates |
Previous Message | Harshal Dhumal | 2016-02-10 13:41:30 | Re: Patch sequence node [pgadmin4] |