9.7.7.12 LIST ROLE

Purpose

The LIST ROLE command displays the specified attributes for a role.

Syntax

LIST ROLE [name | filters] [attribute_list] [DETAIL] 

Usage Notes

• name is the name of the role.

• filters is an expression that determines which roles are displayed.

• attribute_list is the attributes to display. The ALL option can be used to display all attributes.

• The DETAIL option formats the output as an attribute on each line, with an attribute descriptor preceding each value.

Examples

Example 9-75 shows the LIST ROLE command.

Example 9-75 Displaying a Role

DBMCLI> LIST ROLE DETAIL

DBMCLI> LIST ROLE where name like 'db_*'