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>Show Roles command</indexterm>
+<indexterm>Show Enabled Roles command</indexterm>
+<indexterm>Show Settable Roles command</indexterm>
@@ -35,6 +39,7 @@
    INDEXES [ IN <i>schemaName</i> | FROM <i>table-Name</i> ] |
    PROCEDURES [ IN <i>schemaName</i> ] |
    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>
+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>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>
+<codeblock>ij&gt; <b>show roles;</b>
+3 rows selected
+ij&gt; <b>show enabled roles;</b>
+2 rows selected
+ij&gt; <b>show settable roles;</b>
+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>

View raw message