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

java.lang.Object
  extended by 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
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 databse 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

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

Built on Thu 2010-12-23 20:49:13+0000, from revision ???

Apache Derby V10.6 Internals - Copyright © 2004,2007 The Apache Software Foundation. All Rights Reserved.