Categories:

Table, View, & Sequence DDL

SHOW ROW ACCESS POLICIES

Lists the row access policies for which you have access privileges. Returns information that includes the creation date, database and schema names, owner, and any available comments.

See also:

Table, View, & Sequence DDL

In this Topic:

Syntax

SHOW ROW ACCESS POLICIES;

Usage Notes

  • Only returns rows for the row access policy owner (i.e. the role with the OWNERSHIP privilege on the row access policy) or a role with the APPLY privilege on the row access policy or a role with the global APPLY ROW ACCESS POLICY privilege.

  • The command does not require a running warehouse to execute.

  • The value for LIMIT rows cannot exceed 10000. If LIMIT rows is omitted, the command results in an error if the result set is larger than 10K rows.

    To view results for which more than 10K records exist, either include LIMIT rows or query the corresponding view in the Information Schema.

  • To post-process the output of this command, you can use the RESULT_SCAN function, which treats the output as a table that can be queried.

Examples

The following example is representative of a user with the ACCOUNTADMIN role executing the query.

show row access policies;

---------------------------------+------+---------------+-------------+-------------------+--------------+---------+
          created_on             | name | database_name | schema_name |       kind        |    owner     | comment |
---------------------------------+------+---------------+-------------+-------------------+--------------+---------+
Fri, 23 Jun 1967 00:00:00 -0700  | P1   | RLS_AUTHZ_DB  | S_D_1       | ROW_ACCESS_POLICY | ACCOUNTADMIN |         |
Fri, 23 Jun 1967 00:00:00 -0700  | P2   | RLS_AUTHZ_DB  | S_D_2       | ROW_ACCESS_POLICY | ACCOUNTADMIN |         |
---------------------------------+------+---------------+-------------+-------------------+--------------+---------+

The following example is representative of a role that does not have USAGE on the parent schema in which row access policies exist and is not the ACCOUNTADMIN role.

show row access policies;

---------------------------------+------+---------------+-------------+-------------------+--------------+---------+
          created_on             | name | database_name | schema_name |       kind        |    owner     | comment |
---------------------------------+------+---------------+-------------+-------------------+--------------+---------+