org.firebirdsql.jdbc.metadata.GetColumnPrivileges Maven / Gradle / Ivy

Go to download
Show more of this group Show more artifacts with this name
Show all versions of jaybird Show documentation
JDBC Driver for the Firebird RDBMS
The newest version!
/*
 * Firebird Open Source JDBC Driver
 *
 * Distributable under LGPL license.
 * You may obtain a copy of the License at http://www.gnu.org/copyleft/lgpl.html
 *
 * This program is distributed in the hope that it will be useful,
 * but WITHOUT ANY WARRANTY; without even the implied warranty of
 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
 * LGPL License for more details.
 *
 * This file was created by members of the firebird development team.
 * All individual contributions remain the Copyright (C) of those
 * individuals.  Contributors to this file are either listed here or
 * can be obtained from a source control history command.
 *
 * All rights reserved.
 */
package org.firebirdsql.jdbc.metadata;

import org.firebirdsql.gds.ng.fields.RowDescriptor;
import org.firebirdsql.gds.ng.fields.RowValue;
import org.firebirdsql.jdbc.DbMetadataMediator;
import org.firebirdsql.jdbc.DbMetadataMediator.MetadataQuery;

import java.sql.ResultSet;
import java.sql.SQLException;

import static org.firebirdsql.gds.ISCConstants.SQL_VARYING;
import static org.firebirdsql.jdbc.metadata.FbMetadataConstants.OBJECT_NAME_LENGTH;
import static org.firebirdsql.jdbc.metadata.PrivilegeMapping.mapPrivilege;

/**
 * Provides the implementation of {@link java.sql.DatabaseMetaData#getColumnPrivileges(String, String, String, String)}.
 * 
 * This implementation returns all privileges, not just from the current user. The JDBC specification is not
 * clear on this. Looking at the Schemata (SQL standard book 11) definition of the {@code COLUMN_PRIVILEGES}
 * view, possibly this should be restricted to the current user and user {@code PUBLIC} (and maybe active roles). This
 * may change in a future version.
 * 
 *
 * @author Mark Rotteveel
 * @since 5
 */
public final class GetColumnPrivileges extends AbstractMetadataMethod {

    private static final String COLUMNPRIV = "COLUMNPRIV";
    private static final RowDescriptor ROW_DESCRIPTOR = DbMetadataMediator.newRowDescriptorBuilder(9)
            .at(0).simple(SQL_VARYING | 1, OBJECT_NAME_LENGTH, "TABLE_CAT", COLUMNPRIV).addField()
            .at(1).simple(SQL_VARYING | 1, OBJECT_NAME_LENGTH, "TABLE_SCHEM", COLUMNPRIV).addField()
            .at(2).simple(SQL_VARYING, OBJECT_NAME_LENGTH, "TABLE_NAME", COLUMNPRIV).addField()
            .at(3).simple(SQL_VARYING, OBJECT_NAME_LENGTH, "COLUMN_NAME", COLUMNPRIV).addField()
            .at(4).simple(SQL_VARYING, OBJECT_NAME_LENGTH, "GRANTOR", COLUMNPRIV).addField()
            .at(5).simple(SQL_VARYING, OBJECT_NAME_LENGTH, "GRANTEE", COLUMNPRIV).addField()
            .at(6).simple(SQL_VARYING, 31, "PRIVILEGE", COLUMNPRIV).addField()
            .at(7).simple(SQL_VARYING, 3, "IS_GRANTABLE", COLUMNPRIV).addField()
            .at(8).simple(SQL_VARYING, OBJECT_NAME_LENGTH, "JB_GRANTEE_TYPE", COLUMNPRIV).addField()
            .toRowDescriptor();

    //@formatter:off
    private static final String GET_COLUMN_PRIVILEGES_START =
            "select distinct \n"
            + "  RF.RDB$RELATION_NAME as TABLE_NAME, \n"
            + "  RF.RDB$FIELD_NAME as COLUMN_NAME, \n"
            + "  UP.RDB$GRANTOR as GRANTOR, \n"
            + "  UP.RDB$USER as GRANTEE, \n"
            + "  UP.RDB$PRIVILEGE as PRIVILEGE, \n"
            + "  UP.RDB$GRANT_OPTION as IS_GRANTABLE,\n"
            + "  T.RDB$TYPE_NAME as JB_GRANTEE_TYPE\n"
            + "from RDB$RELATION_FIELDS RF\n"
            + "inner join RDB$USER_PRIVILEGES UP\n"
            + "  on UP.RDB$RELATION_NAME = RF.RDB$RELATION_NAME \n"
            + "    and (UP.RDB$FIELD_NAME is null or UP.RDB$FIELD_NAME = RF.RDB$FIELD_NAME) \n"
            + "left join RDB$TYPES T\n"
            + "  on T.RDB$FIELD_NAME = 'RDB$OBJECT_TYPE' and T.RDB$TYPE = UP.RDB$USER_TYPE \n"
            // Other privileges don't make sense for column privileges
            + "where UP.RDB$PRIVILEGE in ('A', 'D', 'I', 'R', 'S', 'U')\n"
            // Only tables and views
            + "and UP.RDB$OBJECT_TYPE in (0, 1)\n"
            + "and ";

    // NOTE: Sort by user is not defined in JDBC, but we do this to ensure a consistent order for tests
    private static final String GET_COLUMN_PRIVILEGES_END =
            "\norder by RF.RDB$FIELD_NAME, UP.RDB$PRIVILEGE, UP.RDB$USER";
    //@formatter:on

    GetColumnPrivileges(DbMetadataMediator mediator) {
        super(ROW_DESCRIPTOR, mediator);
    }

    /**
     * @see java.sql.DatabaseMetaData#getColumnPrivileges(String, String, String, String) 
     */
    public ResultSet getColumnPrivileges(String table, String columnNamePattern) throws SQLException  {
        if (table == null || "".equals(columnNamePattern)) {
            return createEmpty();
        }
        Clause tableClause = Clause.equalsClause("RF.RDB$RELATION_NAME", table);
        Clause columnNameClause = new Clause("RF.RDB$FIELD_NAME", columnNamePattern);

        String sql = GET_COLUMN_PRIVILEGES_START
                + tableClause.getCondition(columnNameClause.hasCondition())
                + columnNameClause.getCondition(false)
                + GET_COLUMN_PRIVILEGES_END;
        MetadataQuery metadataQuery = new MetadataQuery(sql, Clause.parameters(tableClause, columnNameClause));
        return createMetaDataResultSet(metadataQuery);
    }

    @Override
    RowValue createMetadataRow(ResultSet rs, RowValueBuilder valueBuilder) throws SQLException {
        return valueBuilder
                .at(0).set(null)
                .at(1).set(null)
                .at(2).setString(rs.getString("TABLE_NAME"))
                .at(3).setString(rs.getString("COLUMN_NAME"))
                .at(4).setString(rs.getString("GRANTOR"))
                .at(5).setString(rs.getString("GRANTEE"))
                .at(6).setString(mapPrivilege(rs.getString("PRIVILEGE")))
                .at(7).setString(rs.getBoolean("IS_GRANTABLE") ? "YES" : "NO")
                .at(8).setString(rs.getString("JB_GRANTEE_TYPE"))
                .toRowValue(false);
    }

    public static GetColumnPrivileges create(DbMetadataMediator mediator) {
        return new GetColumnPrivileges(mediator);
    }
}