forked from docs/doc-exports
luhuayi
177cd61a57
Reviewed-by: Pruthi, Vineet <vineet.pruthi@t-systems.com> Co-authored-by: luhuayi <luhuayi@huawei.com> Co-committed-by: luhuayi <luhuayi@huawei.com>
72 lines
5.9 KiB
HTML
72 lines
5.9 KiB
HTML
<a name="EN-US_TOPIC_0000001764491244"></a><a name="EN-US_TOPIC_0000001764491244"></a>
|
|
|
|
<h1 class="topictitle1">PG_SECLABEL</h1>
|
|
<div id="body8662426"><p id="EN-US_TOPIC_0000001764491244__ab1a8fdacc1b942469a5efddea8feeaa8"><strong id="EN-US_TOPIC_0000001764491244__b4341678010">PG_SECLABEL</strong> records security labels on database objects.</p>
|
|
<p id="EN-US_TOPIC_0000001764491244__a846433a8d5b34a88bb7742665eb125dc">See also <a href="dws_04_0618.html">PG_SHSECLABEL</a>, which performs a similar function for security labels of database objects that are shared across a database cluster.</p>
|
|
|
|
<div class="tablenoborder"><table cellpadding="4" cellspacing="0" summary="" id="EN-US_TOPIC_0000001764491244__t9a6e81b44abe4d42bdf98ebf41bb7c08" frame="border" border="1" rules="all"><caption><b>Table 1 </b>PG_SECLABEL columns</caption><thead align="left"><tr id="EN-US_TOPIC_0000001764491244__r971c0e6481ef485eb4e1de52a8349370"><th align="left" class="cellrowborder" valign="top" width="14.829999999999998%" id="mcps1.3.3.2.5.1.1"><p id="EN-US_TOPIC_0000001764491244__a40d88f74c5814f06ab5d9dc7d4146a83">Name</p>
|
|
</th>
|
|
<th align="left" class="cellrowborder" valign="top" width="11.940000000000001%" id="mcps1.3.3.2.5.1.2"><p id="EN-US_TOPIC_0000001764491244__a1c9b4a9d032d4516a4950e67717d7723">Type</p>
|
|
</th>
|
|
<th align="left" class="cellrowborder" valign="top" width="26.05%" id="mcps1.3.3.2.5.1.3"><p id="EN-US_TOPIC_0000001764491244__ac694f1d7cd3648f9acaeaf29e060dbe4">Reference</p>
|
|
</th>
|
|
<th align="left" class="cellrowborder" valign="top" width="47.18%" id="mcps1.3.3.2.5.1.4"><p id="EN-US_TOPIC_0000001764491244__a9ac3d5367f4344259bdbb3366f4bc833">Description</p>
|
|
</th>
|
|
</tr>
|
|
</thead>
|
|
<tbody><tr id="EN-US_TOPIC_0000001764491244__r111164b07d704188ae77b8a1e8679ecb"><td class="cellrowborder" valign="top" width="14.829999999999998%" headers="mcps1.3.3.2.5.1.1 "><p id="EN-US_TOPIC_0000001764491244__a727c170ca8fd41a78d79b339aeaee00a">objoid</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="11.940000000000001%" headers="mcps1.3.3.2.5.1.2 "><p id="EN-US_TOPIC_0000001764491244__ac07c46f199f34d03bd2c41280b7d0b8e">OID</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="26.05%" headers="mcps1.3.3.2.5.1.3 "><p id="EN-US_TOPIC_0000001764491244__a67036afd42b041f796e3fca0a1fc83e6">Any OID column</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="47.18%" headers="mcps1.3.3.2.5.1.4 "><p id="EN-US_TOPIC_0000001764491244__af91350381ec54cd9b573c020b055e500">OID of the object this security label pertains to</p>
|
|
</td>
|
|
</tr>
|
|
<tr id="EN-US_TOPIC_0000001764491244__r79801a1097474f50aa70f21a86ad2f1e"><td class="cellrowborder" valign="top" width="14.829999999999998%" headers="mcps1.3.3.2.5.1.1 "><p id="EN-US_TOPIC_0000001764491244__ac6215ae93b6e447494ae88b3cad9ce68">classoid</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="11.940000000000001%" headers="mcps1.3.3.2.5.1.2 "><p id="EN-US_TOPIC_0000001764491244__a5733278408584af182ba52db3c7fb32d">OID</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="26.05%" headers="mcps1.3.3.2.5.1.3 "><p id="EN-US_TOPIC_0000001764491244__a7cd8af094ce34a07bf6118ecfce891cf"><a href="dws_04_0578.html">PG_CLASS</a>.oid</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="47.18%" headers="mcps1.3.3.2.5.1.4 "><p id="EN-US_TOPIC_0000001764491244__ad470ba02ac7d431097b35794fae35421">OID of the system catalog that contains the object</p>
|
|
</td>
|
|
</tr>
|
|
<tr id="EN-US_TOPIC_0000001764491244__r9a19e7bc1d8149eb95ed1eb6c0f9ceda"><td class="cellrowborder" valign="top" width="14.829999999999998%" headers="mcps1.3.3.2.5.1.1 "><p id="EN-US_TOPIC_0000001764491244__a14d64c3c157142bb9ea8cd469512dcb9">objsubid</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="11.940000000000001%" headers="mcps1.3.3.2.5.1.2 "><p id="EN-US_TOPIC_0000001764491244__a8afedda1568d479baec8d3f3c5ccef0f">Integer</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="26.05%" headers="mcps1.3.3.2.5.1.3 "><p id="EN-US_TOPIC_0000001764491244__ab62ef2542c5b4f99961feafe4c10dfd8">N/A</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="47.18%" headers="mcps1.3.3.2.5.1.4 "><p id="EN-US_TOPIC_0000001764491244__a47da2337a76942f7ae8734f9bc636478">For a security label on a table column, this is the column number.</p>
|
|
</td>
|
|
</tr>
|
|
<tr id="EN-US_TOPIC_0000001764491244__r215856917c034eb79908012212f45aa7"><td class="cellrowborder" valign="top" width="14.829999999999998%" headers="mcps1.3.3.2.5.1.1 "><p id="EN-US_TOPIC_0000001764491244__a19fc36a50fc641e8be2e0cccd71b0301">provider</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="11.940000000000001%" headers="mcps1.3.3.2.5.1.2 "><p id="EN-US_TOPIC_0000001764491244__a24545496b7124a4681f6af65c6812c6e">Text</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="26.05%" headers="mcps1.3.3.2.5.1.3 "><p id="EN-US_TOPIC_0000001764491244__a3c717cff9ee342bd99b920ad1d5d731f">N/A</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="47.18%" headers="mcps1.3.3.2.5.1.4 "><p id="EN-US_TOPIC_0000001764491244__a94f37876a3904029a3f9bbc94f27ffc3">Label provider associated with this label</p>
|
|
</td>
|
|
</tr>
|
|
<tr id="EN-US_TOPIC_0000001764491244__r6a2b851a06e94db4ba83f1ad4b002f6e"><td class="cellrowborder" valign="top" width="14.829999999999998%" headers="mcps1.3.3.2.5.1.1 "><p id="EN-US_TOPIC_0000001764491244__a0bc87eb43af847798e73f818c0427e76">label</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="11.940000000000001%" headers="mcps1.3.3.2.5.1.2 "><p id="EN-US_TOPIC_0000001764491244__a668cf9e04483407887481efae5e75c75">Text</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="26.05%" headers="mcps1.3.3.2.5.1.3 "><p id="EN-US_TOPIC_0000001764491244__ad5a7eb2f25ef45639597bbc33a735646">N/A</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="47.18%" headers="mcps1.3.3.2.5.1.4 "><p id="EN-US_TOPIC_0000001764491244__a854976d00d8046b2adf7b88c1e383aab">Security label applied to this object</p>
|
|
</td>
|
|
</tr>
|
|
</tbody>
|
|
</table>
|
|
</div>
|
|
</div>
|
|
<div>
|
|
<div class="familylinks">
|
|
<div class="parentlink"><strong>Parent topic:</strong> <a href="dws_04_0561.html">System Catalogs</a></div>
|
|
</div>
|
|
</div>
|
|
|