Thread: [pgAdmin4][Patch]: Macros for the functions module
Hi,
Please find attached patch for the Security Labels, Privileges and Variables macros for the functions modules.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
Attachment
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