reference/uodbc/functions/odbc-tableprivileges.xml
902c2b77f827e8d0ecccf4f62fb90065d2f6ef79
...
...
@@ -9,11 +9,11 @@
9
9
<refsect1 role="description">
10
10
&reftitle.description;
11
11
<methodsynopsis>
12
-
<type>resource</type><methodname>odbc_tableprivileges</methodname>
13
-
<methodparam><type>resource</type><parameter>connection_id</parameter></methodparam>
14
-
<methodparam><type>string</type><parameter>qualifier</parameter></methodparam>
15
-
<methodparam><type>string</type><parameter>owner</parameter></methodparam>
16
-
<methodparam><type>string</type><parameter>name</parameter></methodparam>
12
+
<type class="union"><type>resource</type><type>false</type></type><methodname>odbc_tableprivileges</methodname>
13
+
<methodparam><type>resource</type><parameter>odbc</parameter></methodparam>
14
+
<methodparam><type class="union"><type>string</type><type>null</type></type><parameter>catalog</parameter></methodparam>
15
+
<methodparam><type>string</type><parameter>schema</parameter></methodparam>
16
+
<methodparam><type>string</type><parameter>table</parameter></methodparam>
17
17
</methodsynopsis>
18
18
<para>
19
19
Lists tables in the requested range and the privileges associated
...
...
@@ -26,34 +26,34 @@
26
26
<para>
27
27
<variablelist>
28
28
<varlistentry>
29
-
<term><parameter>connection_id</parameter></term>
29
+
<term><parameter>odbc</parameter></term>
30
30
<listitem>
31
31
&odbc.connection.id;
32
32
</listitem>
33
33
</varlistentry>
34
34
<varlistentry>
35
-
<term><parameter>qualifier</parameter></term>
35
+
<term><parameter>catalog</parameter></term>
36
36
<listitem>
37
37
<para>
38
-
The qualifier.
38
+
&odbc.parameter.catalog;
39
39
</para>
40
40
</listitem>
41
41
</varlistentry>
42
42
<varlistentry>
43
-
<term><parameter>owner</parameter></term>
43
+
<term><parameter>schema</parameter></term>
44
44
<listitem>
45
45
<para>
46
-
The owner. Accepts the following search patterns:
47
-
('%' to match zero or more characters and '_' to match a single character)
46
+
&odbc.parameter.schema;
47
+
&odbc.parameter.search;
48
48
</para>
49
49
</listitem>
50
50
</varlistentry>
51
51
<varlistentry>
52
-
<term><parameter>name</parameter></term>
52
+
<term><parameter>table</parameter></term>
53
53
<listitem>
54
54
<para>
55
-
The name. Accepts the following search patterns:
56
-
('%' to match zero or more characters and '_' to match a single character)
55
+
The name.
56
+
&odbc.parameter.search;
57
57
</para>
58
58
</listitem>
59
59
</varlistentry>
...
...
@@ -69,23 +69,66 @@
69
69
<para>
70
70
The result set has the following columns:
71
71
<itemizedlist>
72
-
<listitem><simpara>TABLE_QUALIFIER</simpara></listitem>
73
-
<listitem><simpara>TABLE_OWNER</simpara></listitem>
74
-
<listitem><simpara>TABLE_NAME</simpara></listitem>
75
-
<listitem><simpara>GRANTOR</simpara></listitem>
76
-
<listitem><simpara>GRANTEE</simpara></listitem>
77
-
<listitem><simpara>PRIVILEGE</simpara></listitem>
78
-
<listitem><simpara>IS_GRANTABLE</simpara></listitem>
72
+
<listitem><simpara><literal>TABLE_CAT</literal></simpara></listitem>
73
+
<listitem><simpara><literal>TABLE_SCHEM</literal></simpara></listitem>
74
+
<listitem><simpara><literal>TABLE_NAME</literal></simpara></listitem>
75
+
<listitem><simpara><literal>GRANTOR</literal></simpara></listitem>
76
+
<listitem><simpara><literal>GRANTEE</literal></simpara></listitem>
77
+
<listitem><simpara><literal>PRIVILEGE</literal></simpara></listitem>
78
+
<listitem><simpara><literal>IS_GRANTABLE</literal></simpara></listitem>
79
79
</itemizedlist>
80
+
&odbc.result.driver-specific;
80
81
</para>
81
82
<simpara>
82
-
The result set is ordered by TABLE_QUALIFIER, TABLE_OWNER and
83
-
TABLE_NAME.
83
+
The result set is ordered by <literal>TABLE_CAT</literal>, <literal>TABLE_SCHEM</literal>,
84
+
<literal>TABLE_NAME</literal>, <literal>PRIVILEGE</literal> and <literal>GRANTEE</literal>.
84
85
</simpara>
85
86
</refsect1>
86
87

87
-
</refentry>
88
+
<refsect1 role="examples">
89
+
&reftitle.examples;
90
+
<example xml:id="odbc-tableprivileges.example.basic">
91
+
<title>List Privileges of a Table</title>
92
+
<programlisting role="php">
93
+
<![CDATA[
94
+
<?php
95
+
$conn = odbc_connect($dsn, $user, $pass);
96
+
$privileges = odbc_tableprivileges($conn, 'SalesOrders', 'dbo', 'Orders');
97
+
while (($row = odbc_fetch_array($privileges))) {
98
+
print_r($row);
99
+
break; // further rows omitted for brevity
100
+
}
101
+
?>
102
+
]]>
103
+
</programlisting>
104
+
&example.outputs.similar;
105
+
<screen>
106
+
<![CDATA[
107
+
Array
108
+
(
109
+
[TABLE_CAT] => SalesOrders
110
+
[TABLE_SCHEM] => dbo
111
+
[TABLE_NAME] => Orders
112
+
[GRANTOR] => dbo
113
+
[GRANTEE] => dbo
114
+
[PRIVILEGE] => DELETE
115
+
[IS_GRANTABLE] => YES
116
+
)
117
+
]]>
118
+
</screen>
119
+
</example>
120
+
</refsect1>
88
121

122
+
<refsect1 role="seealso">
123
+
&reftitle.seealso;
124
+
<para>
125
+
<simplelist>
126
+
<member><function>odbc_tables</function></member>
127
+
</simplelist>
128
+
</para>
129
+
</refsect1>
130
+

131
+
</refentry>
89
132
<!-- Keep this comment at the end of the file
90
133
Local variables:
91
134
mode: sgml
92
135