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) - redhat
db2_table_privileges(3) - php
db2_columns(3) - php
db2_statistics(3) - php
db2_special_columns(3) - php
Similar Topics in the Unix Linux Community
Export data from DB2 table to .txt file(space delimited)
Upgrading OS from 5.2 to 5.3
select values from db1 table and insert into table of DB2
Asynchronous I/O on AIX and DB performance
Pattern search and count