db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Dag H. Wanvik (JIRA)" <j...@apache.org>
Subject [jira] Created: (DERBY-3133) Syntax for GRANT table permission does nto mention that several privileges may be specified in a list
Date Thu, 18 Oct 2007 11:50:51 GMT
Syntax for GRANT table permission does nto mention that several privileges may be specified
in a list
-----------------------------------------------------------------------------------------------------

                 Key: DERBY-3133
                 URL: https://issues.apache.org/jira/browse/DERBY-3133
             Project: Derby
          Issue Type: Bug
          Components: Documentation
    Affects Versions: 10.3.1.4, 10.2.2.0, 10.2.1.6, 10.4.0.0
            Reporter: Dag H. Wanvik
            Priority: Minor


The syntax is currently specified (in rrefsqljgrant) as:

> GRANT privilege-type ON [TABLE] { table-Name | view-Name } TO grantees
> 
> privilege-type 
> 
>   {
> 	ALL PRIVILEGES |
> 	DELETE |
> 	INSERT |
> 	REFERENCES [column list] |
>  	SELECT [column list] |
> 	TRIGGER |
> 	UPDATE [column list}
>   }

Derby, however, accepts a list of privilege type (see code in
sqlgrammar#tableActions), if the type is not "ALL PRIVILEGES".

Furthermore, column-list is not expanded; it should be because it
needs surrounding parentheses (i.e. it is not just a plain list).

So, the doc for granting table permissions should read something like:

Syntax for tables

GRANT privilege-type ON [TABLE] { table-Name | view-Name } TO grantees

privilege-type 

      ALL PRIVILEGES |
      privilege-list

privilege-list
      table-privilege {, table-privilege }*

Table-privilege
  
	DELETE |
	INSERT |
	REFERENCES [column-list] |
 	SELECT [column-list] |
	TRIGGER |
	UPDATE [column-list}

column-list
        ( column-identifier {, column-identifier}* )


-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


Mime
View raw message