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)