{ “title”: “SHOW ROW POLICY”, “language”: “en”, “description”: “View row security policies. For details on row security policies, refer to the "Security Policies" chapter” }

Description

View row security policies. For details on row security policies, refer to the “Security Policies” chapter

Syntax

SHOW ROW POLICY [ FOR { <user_name> | ROLE <role_name> } ];

Optional Parameters

<user_name>

User name

<role_name>

Role name

Access Control Requirements

The user executing this SQL command must have at least the following privileges:

PrivilegeObjectNotes
ADMIN_PRIVGlobal

Examples

  1. View all security policies
SHOW ROW POLICY;
  1. Query by specifying a user name
SHOW ROW POLICY FOR user1;
  1. Query by specifying a role name
SHOW ROW POLICY for role role1;