3. Statements : OpenROAD SQL Statements : Create Role Statement : Examples—Create Role Statement
 
Share this page                  
Examples—Create Role Statement
The following are create role statement examples:
1. Create a role identifier and password for the inventory application of a bookstore.
create role bks_onhand with password = 'hgwells';
2. Create a role identifier with no password for the daily sales application of the bookstore.
create role dly_sales with nopassword;