svn commit: r835665 - /db/derby/docs/trunk/src/ref/rrefsyscsdiagtables.dita

[bp...@apache.org]

Author: bpendleton
Date: Fri Nov 13 00:30:03 2009
New Revision: 835665

URL: http://svn.apache.org/viewvc?rev=835665&view=rev
Log:
DERBY-4190: Incorrect example for SYSCS_DIAG.CONTAINED_ROLES

This change makes several alterations to the reference guide page regarding
the SYSCS_DIAG.CONTAINED_ROLES table function:
 - the argument to the function needs to be either the keyword CURRENT_ROLE
   or a role name as a quoted string. Since role names, like most identifiers,
   typically occur in upper case, the example uses 'READER' as the example
   role name string.
 - the invocation of the table function in the SELECT statement needs to
   specify a alias name: AS T1.


Modified:
    db/derby/docs/trunk/src/ref/rrefsyscsdiagtables.dita

Modified: db/derby/docs/trunk/src/ref/rrefsyscsdiagtables.dita
URL: http://svn.apache.org/viewvc/db/derby/docs/trunk/src/ref/rrefsyscsdiagtables.dita?rev=835665&r1=835664&r2=835665&view=diff
==============================================================================
--- db/derby/docs/trunk/src/ref/rrefsyscsdiagtables.dita (original)
+++ db/derby/docs/trunk/src/ref/rrefsyscsdiagtables.dita Fri Nov 13 00:30:03 2009
@@ -105,12 +105,18 @@
 an exception.</note></section>
 <section><title>SYSCS_DIAG.CONTAINED_ROLES diagnostic table function</title>
 <p>The SYSCS_DIAG.CONTAINED_ROLES diagnostic table function returns all the
-roles contained within the specified role. For a definition of role containment,
+    roles contained within the specified role. 
+    The argument that is passed to this table function should be the name
+    of the role, specified as a string in quotes, or the special keyword
+    CURRENT_ROLE, which indicates the current role in effect.
+    For a definition of role containment,
 see "Syntax for roles" in
 <xref href="rrefsqljgrant.dita#rrefsqljgrant/grantrolesyn">GRANT
 statement</xref>.</p>
 <p>For example:</p>
-<codeblock>SELECT * FROM TABLE (SYSCS_DIAG.CONTAINED_ROLES(reader))</codeblock>
+<codeblock>SELECT * FROM TABLE (SYSCS_DIAG.CONTAINED_ROLES('READER')) AS T1
+SELECT * FROM TABLE (SYSCS_DIAG.CONTAINED_ROLES(CURRENT_ROLE)) AS T2
+</codeblock>
 </section>
 <section><title>SYSCS_DIAG.ERROR_LOG_READER diagnostic table function</title><p>The
 SYSCS_DIAG.ERROR_LOG_READER diagnostic table function contains all the useful