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