db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Satheesh Bandaram (JIRA)" <derby-...@db.apache.org>
Subject [jira] Commented: (DERBY-1057) documentation to address Grant/Revoke (Derby-464)
Date Tue, 01 Aug 2006 18:44:15 GMT
    [ 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

        

Mime
View raw message