GRANT USAGE ON SCHEME pgroonga

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

First, create a normal user alice by CREATE USER:

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

You can grant USAGE privilege on pgroonga schema to normal user alice by GRANT:

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)