Categories:

Table, View, & Sequence DDL

DESCRIBE ROW ACCESS POLICY

Describes a row access policy, including the creation date, name, data type, and SQL expression.

DESCRIBE can be abbreviated to DESC.

See also:

Table, View, & Sequence DDL

In this Topic:

Syntax

DESC[RIBE] ROW ACCESS POLICY <name>;

Parameters

name

Identifier for the row access policy; must be unique for your account.

The identifier value must start with an alphabetic character and cannot contain spaces or special characters unless the entire identifier string is enclosed in double quotes (e.g. "My object"). Identifiers enclosed in double quotes are also case-sensitive.

For more details, see Identifier Requirements.

Usage Notes

  • This command requires the OWNERSHIP privilege on the schema in which the row access policy exists. A role that has the USAGE privilege on the parent database and schema is not sufficient and results in an error message. For more information, see Troubleshooting Row Access Policies.

Example

The following example describes a row access policy.

DESC ROW ACCESS POLICY rap_table_employee_info;

+-------------------------+-------------+-------------+------+
| name                    |  signature  | return_type | body |
+-------------------------+-------------+-------------+------+
| RAP_TABLE_EMPLOYEE_INFO | (V VARCHAR) | BOOLEAN     | true |
+-------------------------+-------------+-------------+------+