[ 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