Обсуждение: [pgAdmin4][Patch]: Macros for the functions module

Поиск
Список
Период
Сортировка

[pgAdmin4][Patch]: Macros for the functions module

От
Khushboo Vashi
Дата:
Hi,

Please find attached patch for the Security Labels, Privileges and Variables macros for the functions modules.


Usage of the macros:


Security labels:

SECLABLE.SET(conn, 'FUNCTION', func_name, provider, security_label, func_schema, func_args)

SECLABLE.UNSET(conn, 'FUNCTION', func_name, provider, func_schema, func_args)

Privileges:

PRIVILEGE.SET(conn, 'FUNCTION', grantee, func_name, privileges_without_grant, privileges_with_grant, func_schema, func_args)

PRIVILEGE.UNSETALL(conn, 'FUNCTION', grantee, func_name, func_schema, func_args)

Variables:

VARIABLES.SET(conn, 'FUNCTION', func_name, options, func_schema, func_args)

VARIABLES.UNSET(conn, 'FUNCTION', func_name, options, func_schema, func_args)


Thanks,
Khushboo
Вложения

Re: [pgAdmin4][Patch]: Macros for the functions module

От
Dave Page
Дата:
Thanks - applied.

On Thu, Mar 3, 2016 at 7:31 AM, Khushboo Vashi
<khushboo.vashi@enterprisedb.com> wrote:
> Hi,
>
> Please find attached patch for the Security Labels, Privileges and Variables
> macros for the functions modules.
>
>
> Usage of the macros:
>
>
> Security labels:
>
> SECLABLE.SET(conn, 'FUNCTION', func_name, provider, security_label,
> func_schema, func_args)
>
> SECLABLE.UNSET(conn, 'FUNCTION', func_name, provider, func_schema,
> func_args)
>
> Privileges:
>
> PRIVILEGE.SET(conn, 'FUNCTION', grantee, func_name,
> privileges_without_grant, privileges_with_grant, func_schema, func_args)
>
> PRIVILEGE.UNSETALL(conn, 'FUNCTION', grantee, func_name, func_schema,
> func_args)
>
> Variables:
>
> VARIABLES.SET(conn, 'FUNCTION', func_name, options, func_schema, func_args)
>
> VARIABLES.UNSET(conn, 'FUNCTION', func_name, options, func_schema,
> func_args)
>
>
> Thanks,
> Khushboo
>
>
> --
> Sent via pgadmin-hackers mailing list (pgadmin-hackers@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgadmin-hackers
>



--
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company