db-derby-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From chaa...@apache.org
Subject svn commit: r731664 [2/2] - in /db/derby/docs/trunk/src: devguide/ ref/ tools/
Date Mon, 05 Jan 2009 19:50:48 GMT
Modified: db/derby/docs/trunk/src/tools/rtoolsijcomrefshow.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/tools/rtoolsijcomrefshow.dita?rev=731664&r1=731663&r2=731664&view=diff
==============================================================================
--- db/derby/docs/trunk/src/tools/rtoolsijcomrefshow.dita (original)
+++ db/derby/docs/trunk/src/tools/rtoolsijcomrefshow.dita Mon Jan  5 11:50:47 2009
@@ -27,6 +27,10 @@
 <indexterm>Show Schemas command</indexterm><indexterm>Show Views command</indexterm><indexterm>Show
 Procedures command</indexterm><indexterm>Show Synonyms command</indexterm><indexterm>Show
 Indexes in Schema command</indexterm><indexterm>Show Indexes from Table command</indexterm>
+<indexterm>Roles<indexterm>displaying</indexterm></indexterm>
+<indexterm>Show Roles command</indexterm>
+<indexterm>Show Enabled Roles command</indexterm>
+<indexterm>Show Settable Roles command</indexterm>
 </keywords>
 </metadata></prolog>
 <refbody>
@@ -35,6 +39,7 @@
    CONNECTIONS |
    INDEXES [ IN <i>schemaName</i> | FROM <i>table-Name</i> ] |
    PROCEDURES [ IN <i>schemaName</i> ] |
+   [ENABLED | SETTABLE] ROLES |
    SCHEMAS |
    SYNONYMS [ IN <i>schemaName</i> ] |
    TABLES [ IN <i>schemaName</i> ] |
@@ -111,7 +116,45 @@
 SYSCS_UTIL          |SYSCS_SET_STATISTICS_TIMING   |org.apache.derby.ca&amp;
 SYSCS_UTIL          |SYSCS_UNFREEZE_DATABASE       |org.apache.derby.ca&amp;
 
-18 rows selected</codeblock>  <p id="showschemas"><b>SHOW SCHEMAS</b></p>
<p>SHOW
+18 rows selected</codeblock>  
+
+<p id="showroles"><b>SHOW ROLES</b></p>
+<p>SHOW ROLES displays the names of all roles created, whether available or
+settable for the current session or not.</p>
+<p>SHOW ENABLED ROLES displays the names of all the roles whose privileges are
+available for the current session. That is, it shows the current role and any
+role granted to or contained in the current role. (For a definition of role
+containment, see "Using SQL roles" in the
+<ph conref="../conrefs.dita#pub/citdevelop"></ph>.)
+</p>
+<p>SHOW SETTABLE ROLES displays all the roles that the current session can set,
+that is, all roles that have been granted to the current user.</p>
+<p><b>Example</b></p>
+<codeblock>ij&gt; <b>show roles;</b>
+ROLEID                        
+------------------------------
+CASUALUSER                             
+ANYUSER                             
+POWERUSER                             
+
+3 rows selected
+ij&gt; <b>show enabled roles;</b>
+ROLEID                        
+------------------------------
+CASUALUSER                             
+ANYUSER                             
+
+2 rows selected
+ij&gt; <b>show settable roles;</b>
+ROLEID                        
+------------------------------
+CASUALUSER                             
+POWERUSER
+
+2 rows selected
+</codeblock><p>In the examples above, both CASUALUSER and POWERUSER contain
+ANYUSER, but ANYUSER is not settable directly.</p>
+<p id="showschemas"><b>SHOW SCHEMAS</b></p> <p>SHOW
 SCHEMAS displays all of the schemas in the current connection.</p> <p><b>Example</b></p>
<codeblock>ij&gt; <b>show schemas;</b>
 TABLE_SCHEM
 ------------------------------



Mime
View raw message