Class DB_GrantRevoke
- java.lang.Object
-
- org.apache.derby.impl.tools.dblook.DB_GrantRevoke
-
public class DB_GrantRevoke extends java.lang.Object
-
-
Constructor Summary
Constructors Constructor Description DB_GrantRevoke()
-
Method Summary
All Methods Static Methods Concrete Methods Modifier and Type Method Description private static java.lang.String
columnPrivStatement(java.sql.ResultSet rs, java.lang.String fullName, java.lang.String authName, java.sql.ResultSet rsCols)
static void
doAuthorizations(java.sql.Connection conn, boolean at10_6)
Generate Grant and Revoke statements if sqlAuthorization is onstatic void
generateAggregatePrivs(java.sql.ResultSet rs)
Generate aggregate privilege statementsprivate static void
generateColumnPrivs(java.sql.ResultSet rs, java.sql.Connection conn)
Generate column privilege statementsstatic void
generateRoutinePrivs(java.sql.ResultSet rs)
Generate routine privilege statementsstatic void
generateSequencePrivs(java.sql.ResultSet rs)
Generate sequence privilege statementsprivate static void
generateTablePrivs(java.sql.ResultSet rs)
Generate table privilege statementsstatic void
generateUDTPrivs(java.sql.ResultSet rs)
Generate udt privilege statementsprivate static java.lang.String
genericPrivStatement(java.lang.String fullName, java.lang.String authName, java.lang.String permission, java.lang.String objectType)
private static java.lang.String
mapColumnsToNames(java.lang.String columns, java.sql.ResultSet rsCols)
Generate one column grant statementprivate static java.lang.String
privTypeToString(java.lang.String privType)
private static java.lang.String
routinePrivStatement(java.lang.String fullName, java.lang.String authName, java.lang.String aliasType)
private static java.lang.String
separatorStr(boolean addSeparator)
private static java.lang.String
tablePrivStatement(java.sql.ResultSet rs, java.lang.String fullName, java.lang.String authName)
Generate table privilege statement for the current row
-
-
-
Method Detail
-
doAuthorizations
public static void doAuthorizations(java.sql.Connection conn, boolean at10_6) throws java.sql.SQLException
Generate Grant and Revoke statements if sqlAuthorization is on- Parameters:
conn
- Connection to useat10_6
- True if the database level is 10.6 or higher- Throws:
java.sql.SQLException
-
generateTablePrivs
private static void generateTablePrivs(java.sql.ResultSet rs) throws java.sql.SQLException
Generate table privilege statements- Parameters:
rs
- Result set holding required information- Throws:
java.sql.SQLException
-
separatorStr
private static java.lang.String separatorStr(boolean addSeparator)
-
tablePrivStatement
private static java.lang.String tablePrivStatement(java.sql.ResultSet rs, java.lang.String fullName, java.lang.String authName) throws java.sql.SQLException
Generate table privilege statement for the current row- Parameters:
rs
- ResultSet holding tableperm informationfullName
- Table's qualified nameauthName
- Authorization id for grant statement- Throws:
java.sql.SQLException
-
generateColumnPrivs
private static void generateColumnPrivs(java.sql.ResultSet rs, java.sql.Connection conn) throws java.sql.SQLException
Generate column privilege statements- Parameters:
rs
- ResultSet holding column privilege informationconn
- Connection to use. Used to get another ResultSet- Throws:
java.sql.SQLException
-
privTypeToString
private static java.lang.String privTypeToString(java.lang.String privType)
-
mapColumnsToNames
private static java.lang.String mapColumnsToNames(java.lang.String columns, java.sql.ResultSet rsCols) throws java.sql.SQLException
Generate one column grant statement- Parameters:
columns
- List of columns to grant required privsrsCols
- ResultSet for mapping column numbers to names- Throws:
java.sql.SQLException
-
columnPrivStatement
private static java.lang.String columnPrivStatement(java.sql.ResultSet rs, java.lang.String fullName, java.lang.String authName, java.sql.ResultSet rsCols) throws java.sql.SQLException
- Parameters:
rs
- ResultSet with info for this GRANT statementfullName
- Full qualified name of the tableauthName
- Authorization name for this GRANTrsCols
- ResultSet for mapping column numbers to names- Throws:
java.sql.SQLException
-
generateUDTPrivs
public static void generateUDTPrivs(java.sql.ResultSet rs) throws java.sql.SQLException
Generate udt privilege statements- Parameters:
rs
- ResultSet holding required information- Throws:
java.sql.SQLException
-
generateSequencePrivs
public static void generateSequencePrivs(java.sql.ResultSet rs) throws java.sql.SQLException
Generate sequence privilege statements- Parameters:
rs
- ResultSet holding required information- Throws:
java.sql.SQLException
-
generateAggregatePrivs
public static void generateAggregatePrivs(java.sql.ResultSet rs) throws java.sql.SQLException
Generate aggregate privilege statements- Parameters:
rs
- ResultSet holding required information- Throws:
java.sql.SQLException
-
genericPrivStatement
private static java.lang.String genericPrivStatement(java.lang.String fullName, java.lang.String authName, java.lang.String permission, java.lang.String objectType) throws java.sql.SQLException
- Throws:
java.sql.SQLException
-
generateRoutinePrivs
public static void generateRoutinePrivs(java.sql.ResultSet rs) throws java.sql.SQLException
Generate routine privilege statements- Parameters:
rs
- ResultSet holding required information- Throws:
java.sql.SQLException
-
routinePrivStatement
private static java.lang.String routinePrivStatement(java.lang.String fullName, java.lang.String authName, java.lang.String aliasType) throws java.sql.SQLException
- Throws:
java.sql.SQLException
-
-