Class DB_Roles
- java.lang.Object
-
- org.apache.derby.impl.tools.dblook.DB_Roles
-
public class DB_Roles extends java.lang.Object
-
-
Constructor Summary
Constructors Constructor Description DB_Roles()
-
Method Summary
All Methods Static Methods Concrete Methods Modifier and Type Method Description static void
doRoles(java.sql.Connection conn)
Generate role definition statements and role grant statements.private static void
generateRoleDefinitions(java.sql.ResultSet rs)
Generate role definition statementsprivate static void
generateRoleGrants(java.sql.ResultSet rs)
private static java.lang.String
roleDefinitionStatement(java.sql.ResultSet rs, java.lang.String roleName)
Generate a role definition statement for the current rowprivate static java.lang.String
roleGrantStatement(java.sql.ResultSet rs, java.lang.String roleName, java.lang.String grantee, boolean isWithAdminOption)
Generate role grant statement for the current row
-
-
-
Method Detail
-
doRoles
public static void doRoles(java.sql.Connection conn) throws java.sql.SQLException
Generate role definition statements and role grant statements. Note that privileges granted to roles are handled by DB_GrantRevoke, similar to privileges granted to users.- Parameters:
conn
- Connection to use- Throws:
java.sql.SQLException
-
generateRoleDefinitions
private static void generateRoleDefinitions(java.sql.ResultSet rs) throws java.sql.SQLException
Generate role definition statements- Parameters:
rs
- Result set holding required information- Throws:
java.sql.SQLException
-
roleDefinitionStatement
private static java.lang.String roleDefinitionStatement(java.sql.ResultSet rs, java.lang.String roleName) throws java.sql.SQLException
Generate a role definition statement for the current row- Parameters:
rs
-roleName
- The role defined, already quoted- Throws:
java.sql.SQLException
-
generateRoleGrants
private static void generateRoleGrants(java.sql.ResultSet rs) throws java.sql.SQLException
- Throws:
java.sql.SQLException
-
roleGrantStatement
private static java.lang.String roleGrantStatement(java.sql.ResultSet rs, java.lang.String roleName, java.lang.String grantee, boolean isWithAdminOption) throws java.sql.SQLException
Generate role grant statement for the current row- Parameters:
rs
-roleName
- The role granted, already quotedgrantee
- The authorization id to whom the role is granted (a role or a user), already quotedisWithAdminOption
-- Throws:
java.sql.SQLException
-
-