<row>

<entry><literal>object_type</literal></entry>

<entry><type>character_data</type></entry>

<entry><literal>DOMAIN</literal> or <literal>FOREIGN DATA WRAPPER</literal> or <literal>FOREIGN SERVER</literal></entry>

<entry><literal>COLLATION</literal> or <literal>DOMAIN</literal> or <literal>FOREIGN DATA WRAPPER</literal> or <literal>FOREIGN SERVER</literal></entry>

</row>

<row>

<literal>USAGE</literal> privileges granted on various kinds of

objects to a currently enabled role or by a currently enabled role.

In <productname>PostgreSQL</productname>, this currently applies to

domains, foreign-data wrappers, and foreign servers. There is one

collations,domains, foreign-data wrappers, and foreign servers. There is one

row for each combination of object, grantor, and grantee.

</para>

<para>

Since domains do not have real privileges

Sincecollations anddomains do not have real privileges

in <productname>PostgreSQL</productname>, this view shows implicit

non-grantable <literal>USAGE</literal> privileges granted by the

owner to <literal>PUBLIC</literal> for all domains. The other

owner to <literal>PUBLIC</literal> for allcollations anddomains. The other

object types, however, show real privileges.

</para>

<row>

<entry><literal>object_type</literal></entry>

<entry><type>character_data</type></entry>

<entry><literal>DOMAIN</literal> or <literal>FOREIGN DATA WRAPPER</literal> or <literal>FOREIGN SERVER</literal></entry>

<entry><literal>COLLATION</literal> or <literal>DOMAIN</literal> or <literal>FOREIGN DATA WRAPPER</literal> or <literal>FOREIGN SERVER</literal></entry>

</row>

<row>

SELECT CAST(u.rolnameAS sql_identifier)AS grantor,

CAST('PUBLIC'AS sql_identifier)AS grantee,

CAST(current_database()AS sql_identifier)AS object_catalog,

CAST(n.nspnameAS sql_identifier)AS object_schema,

CAST(c.collnameAS sql_identifier)AS object_name,

CAST('COLLATION'AS character_data)AS object_type,

CAST('USAGE'AS character_data)AS privilege_type,

CAST('NO'AS yes_or_no)AS is_grantable

FROM pg_authid u,

pg_namespace n,

pg_collation c

WHEREu.oid=c.collowner

ANDc.collnamespace=n.oid

ANDc.collencoding= (SELECT encodingFROMpg_catalog.pg_databaseWHERE datname=pg_catalog.current_database())

SELECT CAST(u.rolnameAS sql_identifier)AS grantor,