Class ContainedRoles

java.lang.Object
org.apache.derby.vti.VTITemplate
org.apache.derby.diag.ContainedRoles
All Implemented Interfaces:
AutoCloseable, ResultSet, Wrapper, AwareVTI

public class ContainedRoles extends VTITemplate
Contained roles shows all roles contained in the given identifier, or if the second argument, if given, is not 0, the inverse relation; all roles who contain the given role identifier.

To use it, query it as follows:

 SELECT * FROM TABLE(SUSCS_DIAG.CONTAINED_ROLES('FOO')) t; 
 SELECT * FROM TABLE(CONTAINED_ROLES('FOO', 1)) t; 

The following columns will be returned:

  • ROLEID -- VARCHAR(128) NOT NULL