|
|
DB2-JMIN 0.2 (Default branch)
05-21-2008
DB2-JMIN is a general-purpose databaseadministration client, inspired by phpMyAdmin. Itwas originally designed for DB2, but now alsosupports MySQL, PostgreSQL, Firebird, Derby, andOracle. It can be used as a Web application or adesktop application. It runs on Tomcat 5.5 orSwing with JDK 1.5. It features schema browsing,table browsing, table structure, and an SQL queryeditor.License: GNU General Public License v2Changes:|
|
DB2_COLUMN_PRIVILEGES(3) 1 DB2_COLUMN_PRIVILEGES(3) db2_column_privileges - Returns a result set listing the columns and associated privileges for a table SYNOPSIS
resource db2_column_privileges (resource $connection, [string $qualifier], [string $schema], [string $table-name], [string $column- name]) DESCRIPTION
Returns a result set listing the columns and associated privileges for a table. PARAMETERS
o $connection - A valid connection to an IBM DB2, Cloudscape, or Apache Derby database. o $qualifier - A qualifier for DB2 databases running on OS/390 or z/OS servers. For other databases, pass NULL or an empty string. o $schema - The schema which contains the tables. To match all schemas, pass NULL or an empty string. o $table-name - The name of the table or view. To match all tables in the database, pass NULL or an empty string. o $column-name - The name of the column. To match all columns in the table, pass NULL or an empty string. RETURN VALUES
Returns a statement resource with a result set containing rows describing the column privileges for columns matching the specified parame- ters. The rows are composed of the following columns: +-------------+---------------------------------------------------+ |Column name | | | | | | | Description | | | | +-------------+---------------------------------------------------+ | TABLE_CAT | | | | | | | Name of the catalog. The value is NULL if this | | | table does not have catalogs. | | | | |TABLE_SCHEM | | | | | | | Name of the schema. | | | | | TABLE_NAME | | | | | | | Name of the table or view. | | | | |COLUMN_NAME | | | | | | | Name of the column. | | | | | GRANTOR | | | | | | | Authorization ID of the user who granted the | | | privilege. | | | | | GRANTEE | | | | | | | Authorization ID of the user to whom the privi- | | | lege was granted. | | | | | PRIVILEGE | | | | | | | The privilege for the column. | | | | |IS_GRANTABLE | | | | | | | Whether the GRANTEE is permitted to grant this | | | privilege to other users. | | | | +-------------+---------------------------------------------------+ SEE ALSO
db2_columns(3), db2_foreign_keys(3), db2_primary_keys(3), db2_procedure_columns(3), db2_procedures(3), db2_special_columns(3), db2_statis- tics(3), db2_table_privileges(3), db2_tables(3). PHP Documentation Group DB2_COLUMN_PRIVILEGES(3)