org.apache.derby.impl.tools.dblook
Class DB_GrantRevoke

java.lang.Object
  org.apache.derby.impl.tools.dblook.DB_GrantRevoke

public class DB_GrantRevoke
extends java.lang.Object

Constructor Summary

DB_GrantRevoke()

Method Summary

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 & 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

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Detail

DB_GrantRevoke

public DB_GrantRevoke()

Method Detail

doAuthorizations

public static void doAuthorizations(java.sql.Connection conn,
                                    boolean at10_6)
                             throws java.sql.SQLException

Generate Grant & Revoke statements if sqlAuthorization is on

Parameters:

conn - Connection to use

at10_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 information

fullName - Table's qualified name

authName - 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 information

conn - 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 privs

rsCols - 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 statement

fullName - Full qualified name of the table

authName - Authorization name for this GRANT

rsCols - 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