<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> <HTML ><HEAD ><TITLE >db2_table_privileges</TITLE ><META NAME="GENERATOR" CONTENT="Modular DocBook HTML Stylesheet Version 1.79"><LINK REL="HOME" TITLE="PHP 手册" HREF="index.html"><LINK REL="UP" TITLE="IBM DB2, Cloudscape and Apache Derby Functions" HREF="ref.ibm-db2.html"><LINK REL="PREVIOUS" TITLE="db2_stmt_errormsg" HREF="function.db2-stmt-errormsg.html"><LINK REL="NEXT" TITLE="db2_tables" HREF="function.db2-tables.html"><META HTTP-EQUIV="Content-type" CONTENT="text/html; charset=UTF-8"></HEAD ><BODY CLASS="refentry" BGCOLOR="#FFFFFF" TEXT="#000000" LINK="#0000FF" VLINK="#840084" ALINK="#0000FF" ><DIV CLASS="NAVHEADER" ><TABLE SUMMARY="Header navigation table" WIDTH="100%" BORDER="0" CELLPADDING="0" CELLSPACING="0" ><TR ><TH COLSPAN="3" ALIGN="center" >PHP 手册</TH ></TR ><TR ><TD WIDTH="10%" ALIGN="left" VALIGN="bottom" ><A HREF="function.db2-stmt-errormsg.html" ACCESSKEY="P" >上一页</A ></TD ><TD WIDTH="80%" ALIGN="center" VALIGN="bottom" ></TD ><TD WIDTH="10%" ALIGN="right" VALIGN="bottom" ><A HREF="function.db2-tables.html" ACCESSKEY="N" >下一页</A ></TD ></TR ></TABLE ><HR ALIGN="LEFT" WIDTH="100%"></DIV ><H1 ><A NAME="function.db2-table-privileges" ></A >db2_table_privileges</H1 ><DIV CLASS="refnamediv" ><A NAME="AEN83671" ></A ><P > (PECL)</P >db2_table_privileges -- Returns a result set listing the tables and associated privileges in a database </DIV ><DIV CLASS="refsect1" ><A NAME="AEN83674" ></A ><H2 >说明</H2 >resource <B CLASS="methodname" >db2_table_privileges</B > ( resource connection [, string qualifier [, string schema [, string table_name]]] )<BR ></BR ><P > Returns a result set listing the tables and associated privileges in a database. </P ></DIV ><DIV CLASS="refsect1" ><A NAME="AEN83692" ></A ><H2 >参数</H2 ><P > <P ></P ><DIV CLASS="variablelist" ><DL ><DT ><CODE CLASS="parameter" >connection</CODE ></DT ><DD ><P > A valid connection to an IBM DB2, Cloudscape, or Apache Derby database. </P ></DD ><DT ><CODE CLASS="parameter" >qualifier</CODE ></DT ><DD ><P > A qualifier for DB2 databases running on OS/390 or z/OS servers. For other databases, pass <TT CLASS="constant" ><B >NULL</B ></TT > or an empty string. </P ></DD ><DT ><CODE CLASS="parameter" >schema</CODE ></DT ><DD ><P > The schema which contains the tables. This parameter accepts a search pattern containing <TT CLASS="literal" >_</TT > and <TT CLASS="literal" >%</TT > as wildcards. </P ></DD ><DT ><CODE CLASS="parameter" >table_name</CODE ></DT ><DD ><P > The name of the table. This parameter accepts a search pattern containing <TT CLASS="literal" >_</TT > and <TT CLASS="literal" >%</TT > as wildcards. </P ></DD ></DL ></DIV > </P ></DIV ><DIV CLASS="refsect1" ><A NAME="AEN83721" ></A ><H2 >返回值</H2 ><P > Returns a statement resource with a result set containing rows describing the privileges for the tables that match the specified parameters. The rows are composed of the following columns: <DIV CLASS="informaltable" ><P ></P ><A NAME="AEN83724" ></A ><TABLE BORDER="1" CLASS="CALSTABLE" ><COL><COL><THEAD ><TR ><TH >Column name</TH ><TH >Description</TH ></TR ></THEAD ><TBODY ><TR ><TD >TABLE_CAT</TD ><TD >The catalog that contains the table. The value is <TT CLASS="constant" ><B >NULL</B ></TT > if this table does not have catalogs.</TD ></TR ><TR ><TD >TABLE_SCHEM</TD ><TD >Name of the schema that contains the table.</TD ></TR ><TR ><TD >TABLE_NAME</TD ><TD >Name of the table.</TD ></TR ><TR ><TD >GRANTOR</TD ><TD >Authorization ID of the user who granted the privilege.</TD ></TR ><TR ><TD >GRANTEE</TD ><TD >Authorization ID of the user to whom the privilege was granted.</TD ></TR ><TR ><TD >PRIVILEGE</TD ><TD > The privilege that has been granted. This can be one of ALTER, CONTROL, DELETE, INDEX, INSERT, REFERENCES, SELECT, or UPDATE. </TD ></TR ><TR ><TD >IS_GRANTABLE</TD ><TD > A string value of "YES" or "NO" indicating whether the grantee can grant the privilege to other users. </TD ></TR ></TBODY ></TABLE ><P ></P ></DIV > </P ></DIV ><DIV CLASS="refsect1" ><A NAME="AEN83753" ></A ><H2 >参见</H2 ><P > <P ></P ><TABLE BORDER="0" ><TBODY ><TR ><TD ><A HREF="function.db2-column-privileges.html" ><B CLASS="function" >db2_column_privileges()</B ></A ></TD ></TR ><TR ><TD ><A HREF="function.db2-columns.html" ><B CLASS="function" >db2_columns()</B ></A ></TD ></TR ><TR ><TD ><A HREF="function.db2-foreign-keys.html" ><B CLASS="function" >db2_foreign_keys()</B ></A ></TD ></TR ><TR ><TD ><A HREF="function.db2-primary-keys.html" ><B CLASS="function" >db2_primary_keys()</B ></A ></TD ></TR ><TR ><TD ><A HREF="function.db2-procedure-columns.html" ><B CLASS="function" >db2_procedure_columns()</B ></A ></TD ></TR ><TR ><TD ><A HREF="function.db2-procedures.html" ><B CLASS="function" >db2_procedures()</B ></A ></TD ></TR ><TR ><TD ><A HREF="function.db2-special-columns.html" ><B CLASS="function" >db2_special_columns()</B ></A ></TD ></TR ><TR ><TD ><A HREF="function.db2-statistics.html" ><B CLASS="function" >db2_statistics()</B ></A ></TD ></TR ><TR ><TD ><A HREF="function.db2-tables.html" ><B CLASS="function" >db2_tables()</B ></A ></TD ></TR ></TBODY ></TABLE ><P ></P > </P ></DIV ><DIV CLASS="NAVFOOTER" ><HR ALIGN="LEFT" WIDTH="100%"><TABLE SUMMARY="Footer navigation table" WIDTH="100%" BORDER="0" CELLPADDING="0" CELLSPACING="0" ><TR ><TD WIDTH="33%" ALIGN="left" VALIGN="top" ><A HREF="function.db2-stmt-errormsg.html" ACCESSKEY="P" >上一页</A ></TD ><TD WIDTH="34%" ALIGN="center" VALIGN="top" ><A HREF="index.html" ACCESSKEY="H" >起始页</A ></TD ><TD WIDTH="33%" ALIGN="right" VALIGN="top" ><A HREF="function.db2-tables.html" ACCESSKEY="N" >下一页</A ></TD ></TR ><TR ><TD WIDTH="33%" ALIGN="left" VALIGN="top" >db2_stmt_errormsg</TD ><TD WIDTH="34%" ALIGN="center" VALIGN="top" ><A HREF="ref.ibm-db2.html" ACCESSKEY="U" >上一级</A ></TD ><TD WIDTH="33%" ALIGN="right" VALIGN="top" >db2_tables</TD ></TR ></TABLE ></DIV ></BODY ></HTML >