php man page for db2_table_privileges

Query: db2_table_privileges

OS: php

Section: 3

Format: Original Unix Latex Style Formatted with HTML and a Horizontal Scroll Bar

DB2_TABLE_PRIVILEGES(3) 						 1						   DB2_TABLE_PRIVILEGES(3)

db2_table_privileges - Returns a result set listing the tables and associated privileges in a database

SYNOPSIS
resource db2_table_privileges (resource $connection, [string $qualifier], [string $schema], [string $table_name])
DESCRIPTION
Returns a result set listing the tables and associated privileges in a database.
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. This parameter accepts a search pattern containing _ and % as wildcards. o $table_name - The name of the table. This parameter accepts a search pattern containing _ and % as wildcards.
RETURN VALUES
Returns a statement resource with a result set containing rows describing the privileges for the tables that match the specified parame- ters. The rows are composed of the following columns: +-------------+---------------------------------------------------+ |Column name | | | | | | | Description | | | | +-------------+---------------------------------------------------+ | TABLE_CAT | | | | | | | The catalog that contains the table. The value is | | | NULL if this table does not have catalogs. | | | | |TABLE_SCHEM | | | | | | | Name of the schema that contains the table. | | | | | TABLE_NAME | | | | | | | Name of the table. | | | | | 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 that has been granted. This can be | | | one of ALTER, CONTROL, DELETE, INDEX, INSERT, | | | REFERENCES, SELECT, or UPDATE. | | | | |IS_GRANTABLE | | | | | | | A string value of "YES" or "NO" indicating | | | whether the grantee can grant the privilege to | | | other users. | | | | +-------------+---------------------------------------------------+
SEE ALSO
db2_column_privileges(3), db2_columns(3), db2_foreign_keys(3), db2_primary_keys(3), db2_procedure_columns(3), db2_procedures(3), db2_spe- cial_columns(3), db2_statistics(3), db2_tables(3). PHP Documentation Group DB2_TABLE_PRIVILEGES(3)
Related Man Pages
grant(7) - suse
capture-schema(1m) - sunos
db2_procedures(3) - php
db2_column_privileges(3) - php
db2_columns(3) - php
Similar Topics in the Unix Linux Community
How to connect with oracle database using unix...
Upgrading OS from 5.2 to 5.3
Run DB2 export command in loop
Pattern search and count
Read parameter file in a shell script to unload a DB2 Table???