db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Laura Stewart (JIRA)" <derby-...@db.apache.org>
Subject [jira] Updated: (DERBY-1057) documentation to address Grant/Revoke (Derby-464)
Date Thu, 27 Jul 2006 20:25:14 GMT
     [ http://issues.apache.org/jira/browse/DERBY-1057?page=all ]

Laura Stewart updated DERBY-1057:
---------------------------------

    Attachment: ref_html2.zip

I have updated the Reference Manual topics for Grant/Revoke.  However there are several questions
that I have which I need your help answering:

GRANT (file = rrefsqljgrant.html)
1. In the spec, does "signature = ( data-type, ...)", apply to GRANT or just REVOKE?
2. I think that we need to have an example that shows how to specify more than one privilege
(if that is possible). For example: GRANT SELECT, UPDATE ON TABLE t TO maria,harry. Or does
each privilege need to be specified in separate statements?

REVOKE (file = rrefsqljrevoke.html)
1. Does the RESTRICT apply to both procedures and functions or just procedures?
2. The spec does not provide a clear explanation of what "signature" is. The spec has "signature
= ( data-type, ... )", and the examples do not show this used, so it is difficult to know
what is appropriate
to document here for the syntax. Please advise.
3. I think that we need to have an example that shows how to specify more than one privilege
(if that is possible). For example: REVOKE SELECT, UPDATE ON TABLE t TO maria,harry. Or does
each privilege need
to be specified in a separate statement?

SYSREQUIREDPERM (file = rrefsistabssysrequiredperm.html)
1. This table was documented in V2 of the spec but is missing (not crossed out) from subsequent
versions of Derby-464 spec. Please confirm that this table is still needed. Please add it
back into the spec
or add it back in with strikethrough to indicate it is no longer required.

SYSTABLEPERMS (file = rrefsistabssystableperms.html)
1. I believe that the description for TABLEID is not correct. Please see the description for
TABLEID in the file for the SYSCOLPERMS table.

> documentation to address Grant/Revoke (Derby-464)
> -------------------------------------------------
>
>                 Key: DERBY-1057
>                 URL: http://issues.apache.org/jira/browse/DERBY-1057
>             Project: Derby
>          Issue Type: Sub-task
>          Components: Documentation
>    Affects Versions: 10.0.2.0
>            Reporter: Eric Radzinski
>         Assigned To: Laura Stewart
>             Fix For: 10.2.0.0
>
>         Attachments: derby1057_devguide.diff, derby1057_devguide_html.zip, derby1057_ref.diff,
derby1057_ref_html.zip, devguide_html2.zip, ref_html2.zip
>
>


-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

Mime
View raw message