Return-Path: Delivered-To: apmail-db-derby-dev-archive@www.apache.org Received: (qmail 45540 invoked from network); 19 Oct 2007 17:38:16 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 19 Oct 2007 17:38:16 -0000 Received: (qmail 85113 invoked by uid 500); 19 Oct 2007 17:37:59 -0000 Delivered-To: apmail-db-derby-dev-archive@db.apache.org Received: (qmail 85084 invoked by uid 500); 19 Oct 2007 17:37:59 -0000 Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: Delivered-To: mailing list derby-dev@db.apache.org Received: (qmail 85074 invoked by uid 99); 19 Oct 2007 17:37:59 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 19 Oct 2007 10:37:59 -0700 X-ASF-Spam-Status: No, hits=-100.0 required=10.0 tests=ALL_TRUSTED X-Spam-Check-By: apache.org Received: from [140.211.11.4] (HELO brutus.apache.org) (140.211.11.4) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 19 Oct 2007 17:38:11 +0000 Received: from brutus (localhost [127.0.0.1]) by brutus.apache.org (Postfix) with ESMTP id 922C8714208 for ; Fri, 19 Oct 2007 10:37:50 -0700 (PDT) Message-ID: <6222246.1192815470589.JavaMail.jira@brutus> Date: Fri, 19 Oct 2007 10:37:50 -0700 (PDT) From: "Laura Stewart (JIRA)" To: derby-dev@db.apache.org Subject: [jira] Commented: (DERBY-2914) new stored procedures, SYSCS_UTIL.SYSCS_SET_USER_ACCESS, SYSCS_UTIL.SYSCS_GET_USER_ACCESS, SYSCS_UTIL.SYSCS_EMPTY_STATEMENT_CACHE() should get documented In-Reply-To: <8744650.1184027224446.JavaMail.jira@brutus> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-Virus-Checked: Checked by ClamAV on apache.org [ https://issues.apache.org/jira/browse/DERBY-2914?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12536287 ] Laura Stewart commented on DERBY-2914: -------------------------------------- John - I have moved the SYSCS_UTIL.SYSCS_GET_USER_ACCESS topic to the "Built-in functions" section of the reference manual. I added the description for USERNAME but modified it slightly (it should not be "on" :-) An input argument of type VARCHAR(128) that specifies the user ID that is registered in the Derby database. QUESTION - The NULL value says "Removes the user from the list of permissions, reverting the user to the default permission." Is the default permission READONLYACCESS ??? I'd like to clarify that if possible. > new stored procedures, SYSCS_UTIL.SYSCS_SET_USER_ACCESS, SYSCS_UTIL.SYSCS_GET_USER_ACCESS, SYSCS_UTIL.SYSCS_EMPTY_STATEMENT_CACHE() should get documented > --------------------------------------------------------------------------------------------------------------------------------------------------------- > > Key: DERBY-2914 > URL: https://issues.apache.org/jira/browse/DERBY-2914 > Project: Derby > Issue Type: Improvement > Components: Documentation > Affects Versions: 10.3.1.4, 10.4.0.0 > Reporter: Myrna van Lunteren > Assignee: Laura Stewart > Fix For: 10.3.1.5, 10.3.2.0, 10.4.0.0 > > Attachments: derby2914_1.diff, derby2914_2.diff, rrefemptystmtcache.html, rrefemptystmtcache.html, rrefgetuseraccess.html, rrefgetuseraccess.html, rrefgetuseraccess.html, rrefsetuseraccess.html, rrefsetuseraccess.html, rrefsetuseraccess.html > > > With DERBY-2772 and DERBY-2735 3 new procedures > SYSCS_UTIL.SYSCS_SET_USER_ACCESS, SYSCS_UTIL.SYSCS_GET_USER_ACCESS and SYSCS_UTIL.SYSCS_EMPTY_STATEMENT_CACHE() > were created; they need to be documented in the reference manual. -- This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online.