grant-usage-on-schema-pgroonga.md

title
GRANT USAGE ON SCHEME pgroonga

GRANT USAGE ON SCHEME pgroonga

pgroonga schema is deprecated since 2.0.0. Use pgroonga_* functions, operators and operator classes in the current schema for newly written code.

PGroonga defines functions, operators, operator classes and so on into pgroonga schema. Only superuser can use features in pgroonga schema by default. Superuser needs to grant USAGE privilege on pgroonga schema to normal users who want to use PGroonga.

This document describes how to grant USAGE privilege on pgroonga schema to a normal user.

Create a normal user {#create-user}

First, create a normal user alice by [CREATE USER]({{ site.postgresql_doc_base_url.en }}/sql-createuser.html):

CREATE USER alice;

Normal user alice can't access any objects in pgroonga schema at this time. For example, alice can't use pgroonga.snippet_html function:

SELECT pgroonga.snippet_html('PGroonga is fast', Array['fast']);
-- ERROR:  permission denied for schema pgroonga
-- LINE 1: SELECT pgroonga.snippet_html('PGroonga is fast', Array['fast...
--                ^

You need to grant USAGE privilege on pgroonga schema to alice.

Grant USAGE privilege on pgroonga schema {#grant}

You can grant USAGE privilege on pgroonga schema to normal user alice by [GRANT]({{ site.postgresql_doc_base_url.en }}/sql-grant.html):

GRANT USAGE ON SCHEMA pgroonga TO alice;

Now, alice can use all features in pgroonga schema. For example, alice can use pgroonga.snippet_html function:

SELECT pgroonga.snippet_html('PGroonga is fast', Array['fast']);
--                     snippet_html                     
-- -----------------------------------------------------
--  {"PGroonga is <span class=\"keyword\">fast</span>"}
-- (1 row)