[ 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
