public class DB_GrantRevoke
extends java.lang.Object
Constructor and Description |
---|
DB_GrantRevoke() |
Modifier and Type | Method and 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 on
|
static void |
generateAggregatePrivs(java.sql.ResultSet rs)
Generate aggregate privilege statements
|
private static void |
generateColumnPrivs(java.sql.ResultSet rs,
java.sql.Connection conn)
Generate column privilege statements
|
static void |
generateRoutinePrivs(java.sql.ResultSet rs)
Generate routine privilege statements
|
static void |
generateSequencePrivs(java.sql.ResultSet rs)
Generate sequence privilege statements
|
private static void |
generateTablePrivs(java.sql.ResultSet rs)
Generate table privilege statements
|
static void |
generateUDTPrivs(java.sql.ResultSet rs)
Generate udt privilege statements
|
private 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 statement
|
private 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
|
public static void doAuthorizations(java.sql.Connection conn, boolean at10_6) throws java.sql.SQLException
conn
- Connection to useat10_6
- True if the database level is 10.6 or higherjava.sql.SQLException
private static void generateTablePrivs(java.sql.ResultSet rs) throws java.sql.SQLException
rs
- Result set holding required informationjava.sql.SQLException
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) throws java.sql.SQLException
rs
- ResultSet holding tableperm informationfullName
- Table's qualified nameauthName
- Authorization id for grant statementjava.sql.SQLException
private static void generateColumnPrivs(java.sql.ResultSet rs, java.sql.Connection conn) throws java.sql.SQLException
rs
- ResultSet holding column privilege informationconn
- Connection to use. Used to get another ResultSetjava.sql.SQLException
private static java.lang.String privTypeToString(java.lang.String privType)
private static java.lang.String mapColumnsToNames(java.lang.String columns, java.sql.ResultSet rsCols) throws java.sql.SQLException
columns
- List of columns to grant required privsrsCols
- ResultSet for mapping column numbers to namesjava.sql.SQLException
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
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 namesjava.sql.SQLException
public static void generateUDTPrivs(java.sql.ResultSet rs) throws java.sql.SQLException
rs
- ResultSet holding required informationjava.sql.SQLException
public static void generateSequencePrivs(java.sql.ResultSet rs) throws java.sql.SQLException
rs
- ResultSet holding required informationjava.sql.SQLException
public static void generateAggregatePrivs(java.sql.ResultSet rs) throws java.sql.SQLException
rs
- ResultSet holding required informationjava.sql.SQLException
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
java.sql.SQLException
public static void generateRoutinePrivs(java.sql.ResultSet rs) throws java.sql.SQLException
rs
- ResultSet holding required informationjava.sql.SQLException
private static java.lang.String routinePrivStatement(java.lang.String fullName, java.lang.String authName, java.lang.String aliasType) throws java.sql.SQLException
java.sql.SQLException
Apache Derby V10.13 Internals - Copyright © 2004,2016 The Apache Software Foundation. All Rights Reserved.