Skip to main content
Get StartedConsole GuideWork With DataRelease NotesReference
Resources
VeloDB Cloud 26.x·Apache Doris 4.x (up to 4.0 supported)·"Since X.Y" tags refer to Apache Doris versionsVersion mapping

SHOW ROW POLICY

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;