<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" lang="en-us" xml:lang="en-us">
<!--
  Licensed to the Apache Software Foundation (ASF) under one or more
  contributor license agreements.  See the NOTICE file distributed with
  this work for additional information regarding copyright ownership.
  The ASF licenses this file to You under the Apache License, Version 2.0
  (the "License"); you may not use this file except in compliance with
  the License.  You may obtain a copy of the License at

      http://www.apache.org/licenses/LICENSE-2.0

  Unless required by applicable law or agreed to in writing, software
  distributed under the License is distributed on an "AS IS" BASIS,
  WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
  See the License for the specific language governing permissions and
  limitations under the License.
-->
<head>
<meta content="text/html; charset=utf-8" http-equiv="Content-Type" />
<meta name="copyright" content="(C) Copyright 2005" />
<meta name="DC.rights.owner" content="(C) Copyright 2005" />
<meta content="public" name="security" />
<meta content="index,follow" name="Robots" />
<meta http-equiv="PICS-Label" content='(PICS-1.1 "http://www.icra.org/ratingsv02.html" l gen true r (cz 1 lz 1 nz 1 oz 1 vz 1) "http://www.rsac.org/ratingsv01.html" l gen true r (n 0 s 0 v 0 l 0) "http://www.classify.org/safesurf/" l gen true r (SS~~000 1))' />
<meta content="reference" name="DC.Type" />
<meta name="DC.Title" content="SYSCOLPERMS system table" />
<meta name="abstract" content="The SYSCOLPERMS table stores the column permissions that have been granted but not revoked." />
<meta name="description" content="The SYSCOLPERMS table stores the column permissions that have been granted but not revoked." />
<meta content="system tables, SYSCOLPERMS, permissions, SYSCOLPERMS system table" name="DC.subject" />
<meta content="system tables, SYSCOLPERMS, permissions, SYSCOLPERMS system table" name="keywords" />
<meta scheme="URI" name="DC.Relation" content="rrefsqljrevoke.html" />
<meta scheme="URI" name="DC.Relation" content="rrefsqljgrant.html" />
<meta scheme="URI" name="DC.Relation" content="rrefsqljrevoke.html" />
<meta scheme="URI" name="DC.Relation" content="rrefsistabs38369.html" />
<meta content="XHTML" name="DC.Format" />
<meta content="rrefsistabssyscolperms" name="DC.Identifier" />
<meta content="en-us" name="DC.Language" />
<link href="commonltr.css" type="text/css" rel="stylesheet" />
<title>SYSCOLPERMS system table</title>
</head>
<body id="rrefsistabssyscolperms"><a name="rrefsistabssyscolperms"><!-- --></a>


<h1 class="topictitle1">SYSCOLPERMS system table</h1>



<div><p>The SYSCOLPERMS table stores the column permissions that have been
granted but not revoked.</p>

<div class="section"><p>All of the permissions for one (GRANTEE, TABLEID, TYPE, GRANTOR)
combination are specified in a single row in the SYSCOLPERMS table. The keys
for the SYSCOLPERMS table are:</p>

<ul>
<li>Primary key (GRANTEE, TABLEID, TYPE, GRANTOR)</li>

<li>Unique key (COLPERMSID)</li>

<li>Foreign key (TABLEID references SYS.SYSTABLES)</li>

</ul>

<p>The following table shows the contents of the SYSCOLPERMS system table.</p>


<div class="tablenoborder"><table cellspacing="0" cellpadding="4" summary="For each column in the SYSCOLPERMS system table, this table provides its data type, its length in bytes, whether it is nullable, and a description of its contents." frame="border" border="1" rules="all"><caption>Table 1. SYSCOLPERMS system table</caption>





<thead align="left">
<tr valign="bottom">
<th valign="bottom" width="28.999999999999996%" id="N100BC">Column Name</th>

<th valign="bottom" width="24%" id="N100C3">Type</th>

<th valign="bottom" width="11%" id="N100CA">Length</th>

<th valign="bottom" width="12%" id="N100D1">Nullable</th>

<th valign="bottom" width="24%" id="N100D8">Contents</th>

</tr>

</thead>

<tbody>
<tr>
<td valign="top" width="28.999999999999996%" headers="N100BC">COLPERMSID</td>

<td valign="top" width="24%" headers="N100C3">CHAR</td>

<td valign="top" width="11%" headers="N100CA">36</td>

<td valign="top" width="12%" headers="N100D1">false</td>

<td valign="top" width="24%" headers="N100D8">Used by the dependency manager to track the dependency
of a view, trigger, or constraint on the column level permissions</td>

</tr>

<tr>
<td valign="top" width="28.999999999999996%" headers="N100BC">GRANTEE</td>

<td valign="top" width="24%" headers="N100C3">VARCHAR</td>

<td valign="top" width="11%" headers="N100CA">128</td>

<td valign="top" width="12%" headers="N100D1">false</td>

<td valign="top" width="24%" headers="N100D8">The authorization ID of the user or role to which the
privilege was granted</td>

</tr>

<tr>
<td valign="top" width="28.999999999999996%" headers="N100BC">GRANTOR</td>

<td valign="top" width="24%" headers="N100C3">VARCHAR</td>

<td valign="top" width="11%" headers="N100CA">128</td>

<td valign="top" width="12%" headers="N100D1">false</td>

<td valign="top" width="24%" headers="N100D8">The authorization ID of the user who granted the privilege.
Privileges can be granted only by the object owner</td>

</tr>

<tr>
<td valign="top" width="28.999999999999996%" headers="N100BC">TABLEID</td>

<td valign="top" width="24%" headers="N100C3">CHAR</td>

<td valign="top" width="11%" headers="N100CA">36</td>

<td valign="top" width="12%" headers="N100D1">false</td>

<td valign="top" width="24%" headers="N100D8">The unique identifier for the table on which the permissions
have been granted</td>

</tr>

<tr>
<td valign="top" width="28.999999999999996%" headers="N100BC">TYPE</td>

<td valign="top" width="24%" headers="N100C3">CHAR</td>

<td valign="top" width="11%" headers="N100CA">1</td>

<td valign="top" width="12%" headers="N100D1">false</td>

<td valign="top" width="24%" headers="N100D8">If the privilege is non-grantable, the valid values are:
<p><em>'s'</em> for SELECT<br />
<em>'u'</em> for UPDATE<br />
<em>'r'</em> for REFERENCES<br />
</p>
If the privilege is grantable, the valid values are: 
<p><em>'S'</em> for SELECT<br />
<em>'U'</em> for UPDATE<br />
<em>'R'</em> for REFERENCES</p>
</td>

</tr>

<tr>
<td valign="top" width="28.999999999999996%" headers="N100BC">COLUMNS</td>

<td valign="top" width="24%" headers="N100C3"><em>org.apache.derby.
iapi.services.io.
FormatableBitSet</em>
<p>This class is not part of the public API.</p>
 </td>

<td valign="top" width="11%" headers="N100CA">2,147,483,647</td>

<td valign="top" width="12%" headers="N100D1">false</td>

<td valign="top" width="24%" headers="N100D8">A list of columns to which the privilege applies</td>

</tr>

</tbody>

</table>
</div>

</div>

</div>

<div>
<div class="familylinks">
<div class="parentlink"><strong>Parent topic:</strong> <a href="rrefsistabs38369.html" title="">Derby system tables</a></div>
</div>
<div class="relref"><strong>Related reference</strong><br />
<div><a href="rrefsqljrevoke.html" title="The REVOKE statement removes privileges from a specific user or role, or from all users, to perform actions on database objects.">REVOKE statement</a></div>
<div><a href="rrefsqljgrant.html" title="The GRANT statement gives privileges to a specific user or role, or to all users, to perform actions on database objects.">GRANT statement</a></div>
</div>
</div>

</body>
</html>
