java/testing/org/apache/derbyTesting/functionTests/master/ij_show_roles_usr.out

ij> -- Run via ToolScripts.java
show roles;
ROLEID                        
------------------------------
"eve"                         
A                             
B                             
PUBLICROLE                    
ij> set role b;
0 rows inserted/updated/deleted
ij> show enabled_roles;
ROLEID                        
------------------------------
A                             
B                             
ij> select * from table(syscs_diag.contained_roles(current_role, 0)) t order by roleid;
ROLEID                                                                                                                          
--------------------------------------------------------------------------------------------------------------------------------
A                                                                                                                               
B                                                                                                                               
ij> select * from table(syscs_diag.contained_roles(current_role)) t order by roleid;
ROLEID                                                                                                                          
--------------------------------------------------------------------------------------------------------------------------------
A                                                                                                                               
B                                                                                                                               
ij> select * from table(syscs_diag.contained_roles(current_role, 1)) t order by roleid;
ROLEID                                                                                                                          
--------------------------------------------------------------------------------------------------------------------------------
B                                                                                                                               
ij> select * from table(syscs_diag.contained_roles('a', 0)) t order by roleid;
ROLEID                                                                                                                          
--------------------------------------------------------------------------------------------------------------------------------
A                                                                                                                               
ij> select * from table(syscs_diag.contained_roles('a')) t order by roleid;
ROLEID                                                                                                                          
--------------------------------------------------------------------------------------------------------------------------------
A                                                                                                                               
ij> select * from table(syscs_diag.contained_roles('a', 1)) t order by roleid;
ROLEID                                                                                                                          
--------------------------------------------------------------------------------------------------------------------------------
A                                                                                                                               
B                                                                                                                               
ij> set role none;
0 rows inserted/updated/deleted
ij> show enabled_roles;
ROLEID                        
------------------------------
ij> show settable_roles;
ROLEID                        
------------------------------
B                             
PUBLICROLE                    
ij>