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