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>
65 lines
5.9 KiB
HTML
65 lines
5.9 KiB
HTML
<a name="EN-US_TOPIC_0000001811609925"></a><a name="EN-US_TOPIC_0000001811609925"></a>
|
|
|
|
<h1 class="topictitle1">PG_SHSECLABEL</h1>
|
|
<div id="body8662426"><p id="EN-US_TOPIC_0000001811609925__en-us_topic_0059778891_p163551246038"><strong id="EN-US_TOPIC_0000001811609925__b661733416133">PG_SHSECLABEL</strong> records security labels on shared database objects. Security labels can be manipulated with the <strong id="EN-US_TOPIC_0000001811609925__en-us_topic_0058966229_b842352706221051">SECURITY LABEL</strong> command.</p>
|
|
<p id="EN-US_TOPIC_0000001811609925__a0ee5f26bcaa54e5fbf5c8e302832f0be">For an easier way to view security labels, see <a href="dws_04_0748.html">PG_SECLABELS</a>.</p>
|
|
<p id="EN-US_TOPIC_0000001811609925__a3d410c5739814aa8a589412923c18618">See also <a href="dws_04_0615.html">PG_SECLABEL</a>, which performs a similar function for security labels involving objects within a single database. </p>
|
|
<p id="EN-US_TOPIC_0000001811609925__a8a0eb3ff530846c38c018bca5d076c1f">Unlike most system catalogs, <strong id="EN-US_TOPIC_0000001811609925__b842352706105825">PG_SHSECLABEL</strong> is shared across all databases of a cluster. There is only one copy of <strong id="EN-US_TOPIC_0000001811609925__b842352706105842">PG_SHSECLABEL</strong> per cluster, not one per database. </p>
|
|
|
|
<div class="tablenoborder"><table cellpadding="4" cellspacing="0" summary="" id="EN-US_TOPIC_0000001811609925__tb4416a216db548b9a6a83fb9d202816e" frame="border" border="1" rules="all"><caption><b>Table 1 </b>PG_SHSECLABEL columns</caption><thead align="left"><tr id="EN-US_TOPIC_0000001811609925__r101802d8714241a9afc2bcc34bdc3fc8"><th align="left" class="cellrowborder" valign="top" width="18.04819518048195%" id="mcps1.3.5.2.5.1.1"><p id="EN-US_TOPIC_0000001811609925__a1b7710d4778e4adea35924b59a4deb76">Name</p>
|
|
</th>
|
|
<th align="left" class="cellrowborder" valign="top" width="12.028797120287972%" id="mcps1.3.5.2.5.1.2"><p id="EN-US_TOPIC_0000001811609925__a7632d64e3cc14fa0b371014ce9ad0ce3">Type</p>
|
|
</th>
|
|
<th align="left" class="cellrowborder" valign="top" width="23.30766923307669%" id="mcps1.3.5.2.5.1.3"><p id="EN-US_TOPIC_0000001811609925__ab891a8d906a34c66910f142e6afdd4e6">Reference</p>
|
|
</th>
|
|
<th align="left" class="cellrowborder" valign="top" width="46.61533846615338%" id="mcps1.3.5.2.5.1.4"><p id="EN-US_TOPIC_0000001811609925__adcec287c9ac54f0fa6afc1a117cb61bc">Description</p>
|
|
</th>
|
|
</tr>
|
|
</thead>
|
|
<tbody><tr id="EN-US_TOPIC_0000001811609925__r4950c3bc72264c5d98eaecbacc169bf6"><td class="cellrowborder" valign="top" width="18.04819518048195%" headers="mcps1.3.5.2.5.1.1 "><p id="EN-US_TOPIC_0000001811609925__a7000518c893946869bdcd524a1612ffe">objoid</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="12.028797120287972%" headers="mcps1.3.5.2.5.1.2 "><p id="EN-US_TOPIC_0000001811609925__ae9a615536b0e479f9deaf331278cfd9e">OID</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="23.30766923307669%" headers="mcps1.3.5.2.5.1.3 "><p id="EN-US_TOPIC_0000001811609925__a93903d359d1b4bceb2ef859bf92e9ea0">Any OID column</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="46.61533846615338%" headers="mcps1.3.5.2.5.1.4 "><p id="EN-US_TOPIC_0000001811609925__ac6776ec74eed43a3b2bc8ffe9bcdf58a">OID of the object this security label pertains to</p>
|
|
</td>
|
|
</tr>
|
|
<tr id="EN-US_TOPIC_0000001811609925__r50bb0aa11f1c47918fd55476cc93531c"><td class="cellrowborder" valign="top" width="18.04819518048195%" headers="mcps1.3.5.2.5.1.1 "><p id="EN-US_TOPIC_0000001811609925__a30f3521894424bfb92b26eeb342be84c">classoid</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="12.028797120287972%" headers="mcps1.3.5.2.5.1.2 "><p id="EN-US_TOPIC_0000001811609925__a425a24ec44384b17a8978188f15e150c">OID</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="23.30766923307669%" headers="mcps1.3.5.2.5.1.3 "><p id="EN-US_TOPIC_0000001811609925__a16e08747d0344c63a8ba1d574b2840d0"><a href="dws_04_0578.html">PG_CLASS</a>.oid</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="46.61533846615338%" headers="mcps1.3.5.2.5.1.4 "><p id="EN-US_TOPIC_0000001811609925__aba7b7f6d645b48efb8d9f4bb5fac4281">OID of the system catalog where the object resides</p>
|
|
</td>
|
|
</tr>
|
|
<tr id="EN-US_TOPIC_0000001811609925__r0ddbfb381425415db47ca0b44e4591bd"><td class="cellrowborder" valign="top" width="18.04819518048195%" headers="mcps1.3.5.2.5.1.1 "><p id="EN-US_TOPIC_0000001811609925__ae9bd893caead4143a713657deaf7ec58">provider</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="12.028797120287972%" headers="mcps1.3.5.2.5.1.2 "><p id="EN-US_TOPIC_0000001811609925__af87a3696dfdd408fad6c1af1169050ed">Text</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="23.30766923307669%" headers="mcps1.3.5.2.5.1.3 "><p id="EN-US_TOPIC_0000001811609925__a08451cafbec74e28a125f2f7c5bcc089">N/A</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="46.61533846615338%" headers="mcps1.3.5.2.5.1.4 "><p id="EN-US_TOPIC_0000001811609925__a4f21878345794566bc5b943a722d7e6e">Label provider associated with this label</p>
|
|
</td>
|
|
</tr>
|
|
<tr id="EN-US_TOPIC_0000001811609925__rd8f9935e10694e6299997361efa29593"><td class="cellrowborder" valign="top" width="18.04819518048195%" headers="mcps1.3.5.2.5.1.1 "><p id="EN-US_TOPIC_0000001811609925__aefc65bea509e4a348ec474917394818d">label</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="12.028797120287972%" headers="mcps1.3.5.2.5.1.2 "><p id="EN-US_TOPIC_0000001811609925__ae7cc0d3b7f3544c98f9ba9ace313c3d5">Text</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="23.30766923307669%" headers="mcps1.3.5.2.5.1.3 "><p id="EN-US_TOPIC_0000001811609925__a741076b5bfbe4e2091fc1a309f3462f2">N/A</p>
|
|
</td>
|
|
<td class="cellrowborder" valign="top" width="46.61533846615338%" headers="mcps1.3.5.2.5.1.4 "><p id="EN-US_TOPIC_0000001811609925__ad7568379b1f84f51b5bf1662dbe96f42">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>
|
|
|