|
|
Help Me to Decide
|
|
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)
