You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-dev@db.apache.org by "Satheesh Bandaram (JIRA)" <de...@db.apache.org> on 2006/08/01 20:44:15 UTC
[jira] Commented: (DERBY-1057) documentation to address
Grant/Revoke (Derby-464)
[ http://issues.apache.org/jira/browse/DERBY-1057?page=comments#action_12424974 ]
Satheesh Bandaram commented on DERBY-1057:
------------------------------------------
All the answers provided by Mamta earlier are correct. Grant/Revoke statements can only operate on one object at a time.. though it may be possible to grant/revoke several actions to several different users in one statement. So, all the following are possible:
GRANT SELECT, UPDATE, REFERENCES ON T TO SAM, RAM, PAM;
REVOKE SELECT, UPDATE, REFERENCES ON T FROM SAM, RAM, PAM;
GRANT EXECUTE ON FUNCTION F_ABS123(INT) TO SAM, PAM;
REVOKE EXECUTE ON FUNCTION F_ABS123 FROM SAM, PAM RESTRICT;
But NOT the following:
GRANT SELECT ON T, T1 TO SAM; <==== Granting Select on two different tables in statement
Similarly granting EXECUTE on multiple functions (or procedures) in statement is NOT allowed, same behavior with REVOKE as well.
Regarding routine signatures, I can update the spec to add some grammar info.
Laura, let me know if you need any further info for documentation. BIG thanks for attempting to document this feature.
> 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