diff --git a/web/pgadmin/browser/server_groups/servers/databases/schemas/tables/templates/column/macros/security.macros b/web/pgadmin/browser/server_groups/servers/databases/schemas/tables/templates/column/macros/security.macros index 39587c3..1beb259 100644 --- a/web/pgadmin/browser/server_groups/servers/databases/schemas/tables/templates/column/macros/security.macros +++ b/web/pgadmin/browser/server_groups/servers/databases/schemas/tables/templates/column/macros/security.macros @@ -1,6 +1,6 @@ {% macro APPLY(conn, type, schema_name, parent_object, child_object, provider, label) -%} -SECURITY LABEL FOR {{ conn|qtIdent(provider) }} ON {{ type }} {{ conn|qtIdent(schema_name, parent_object, child_object) }} IS {{ label|qtLiteral }}; +SECURITY LABEL{% if provider and provider != '' %} FOR {{ conn|qtIdent(provider) }}{% endif %} ON {{ type }} {{ conn|qtIdent(schema_name, parent_object, child_object) }} IS {{ label|qtLiteral }}; {%- endmacro %} {% macro DROP(conn, type, schema_name, parent_object, child_object, provider) -%} -SECURITY LABEL FOR {{ conn|qtIdent(provider) }} ON {{ type }} {{ conn|qtIdent(schema_name, parent_object, child_object) }} IS NULL; +SECURITY LABEL{% if provider and provider != '' %} FOR {{ conn|qtIdent(provider) }}{% endif %} ON {{ type }} {{ conn|qtIdent(schema_name, parent_object, child_object) }} IS NULL; {%- endmacro %} diff --git a/web/pgadmin/browser/server_groups/servers/databases/schemas/templates/macros/functions/security.macros b/web/pgadmin/browser/server_groups/servers/databases/schemas/templates/macros/functions/security.macros index dd2a086..5d9e2a6 100644 --- a/web/pgadmin/browser/server_groups/servers/databases/schemas/templates/macros/functions/security.macros +++ b/web/pgadmin/browser/server_groups/servers/databases/schemas/templates/macros/functions/security.macros @@ -2,7 +2,7 @@ {# Macros for Security Labels (functions module) #} {#################################################} {% macro SET(conn, type, name, provider, label, schema, func_args) -%} -SECURITY LABEL FOR {{ provider }} ON {{ type }} {{ conn|qtIdent(schema, name) }}({{func_args}}) IS {{ label|qtLiteral }}; +SECURITY LABEL{% if provider and provider != '' %} FOR {{ conn|qtIdent(provider) }}{% endif %} ON {{ type }} {{ conn|qtIdent(schema, name) }}({{func_args}}) IS {{ label|qtLiteral }}; {%- endmacro %} {% macro UNSET(conn, type, name, provider, schema, func_args) -%} SECURITY LABEL FOR {{ provider }} ON {{ type }} {{ conn|qtIdent(schema, name) }}({{func_args}}) IS NULL; diff --git a/web/pgadmin/browser/server_groups/servers/databases/schemas/templates/macros/schemas/security.macros b/web/pgadmin/browser/server_groups/servers/databases/schemas/templates/macros/schemas/security.macros index e1126b1..7d764c5 100644 --- a/web/pgadmin/browser/server_groups/servers/databases/schemas/templates/macros/schemas/security.macros +++ b/web/pgadmin/browser/server_groups/servers/databases/schemas/templates/macros/schemas/security.macros @@ -2,7 +2,7 @@ {# Macros for schema and its child nodes #} {##########################################} {% macro SET(conn, type, name, provider, label, schema) -%} -SECURITY LABEL FOR {{ provider }} ON {{ type }} {{ conn|qtIdent(schema, name) }} IS {{ label|qtLiteral }}; +SECURITY LABEL FOR{% if provider and provider != '' %} FOR {{ conn|qtIdent(provider) }}{% endif %} ON {{ type }} {{ conn|qtIdent(schema, name) }} IS {{ label|qtLiteral }}; {%- endmacro %} {% macro UNSET(conn, type, name, provider, schema) -%} SECURITY LABEL FOR {{ provider }} ON {{ type }} {{ conn|qtIdent(schema, name) }} IS NULL; diff --git a/web/pgadmin/browser/server_groups/servers/templates/macros/security.macros b/web/pgadmin/browser/server_groups/servers/templates/macros/security.macros index 83fb9d2..4350f9a 100644 --- a/web/pgadmin/browser/server_groups/servers/templates/macros/security.macros +++ b/web/pgadmin/browser/server_groups/servers/templates/macros/security.macros @@ -1,5 +1,5 @@ {% macro APPLY(conn, type, name, provider, label) -%} -SECURITY LABEL FOR {{ conn|qtIdent(provider) }} ON {{ type }} {{ conn|qtIdent(name) }} IS {{ label|qtLiteral }}; +SECURITY LABEL{% if provider and provider != '' %} FOR {{ conn|qtIdent(provider) }}{% endif %} ON {{ type }} {{ conn|qtIdent(name) }} IS {{ label|qtLiteral }}; {%- endmacro %} {% macro DROP(conn, type, name, provider) -%} SECURITY LABEL FOR {{ conn|qtIdent(provider) }} ON {{ type }} {{ conn|qtIdent(name) }} IS NULL; diff --git a/web/pgadmin/browser/server_groups/servers/templates/servers/servers.js b/web/pgadmin/browser/server_groups/servers/templates/servers/servers.js index 1c8bff8..0a64143 100644 --- a/web/pgadmin/browser/server_groups/servers/templates/servers/servers.js +++ b/web/pgadmin/browser/server_groups/servers/templates/servers/servers.js @@ -23,14 +23,6 @@ function($, _, S, pgAdmin, pgBrowser, alertify) { errmsg = null; this.errorModel.clear(); - if (_.isUndefined(this.get('provider')) || - _.isNull(this.get('provider')) || - String(this.get('provider')).replace(/^\s+|\s+$/g, '') == '') { - errmsg = '{{ _('Provider must be specified.') }}'; - this.errorModel.set('provider', errmsg); - return errmsg; - } - if (_.isUndefined(this.get('label')) || _.isNull(this.get('label')) || String(this.get('label')).replace(/^\s+|\s+$/g, '') == '') {