db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Laura Stewart (JIRA)" <j...@apache.org>
Subject [jira] Updated: (DERBY-3133) Syntax for GRANT table permission does not mention that several privileges may be specified in a list
Date Mon, 29 Oct 2007 23:18:50 GMT

     [ https://issues.apache.org/jira/browse/DERBY-3133?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Laura Stewart updated DERBY-3133:
---------------------------------

    Attachment: rrefsqljrevoke.dita
                rrefsqljgrant.dita
                derby3133_3.diff

Dag - I made the update to the privileges label but I think that the recommendation about

the column list is not necessary, The syntax shows what is needed.



> Syntax for GRANT table permission does not 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.2.1.6, 10.2.2.0, 10.3.1.4, 10.4.0.0
>            Reporter: Dag H. Wanvik
>            Assignee: Laura Stewart
>            Priority: Minor
>         Attachments: derby3133_1.diff, derby3133_2.diff, derby3133_3.diff, rrefsqljgrant-2.html,
rrefsqljgrant.dita, rrefsqljgrant.html, rrefsqljgrant.html, rrefsqljrevoke-2.html, rrefsqljrevoke.dita,
rrefsqljrevoke.html, rrefsqljrevoke.html
>
>
> 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