db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Yip Ng (JIRA)" <derby-...@db.apache.org>
Subject [jira] Commented: (DERBY-1839) Doc Review Updates - Ref Manual
Date Tue, 19 Sep 2006 22:56:23 GMT
    [ http://issues.apache.org/jira/browse/DERBY-1839?page=comments#action_12436045 ] 
Yip Ng commented on DERBY-1839:


"The view owner can only grant the SELECT privilege to other users if the view owner also
owns the underlying objects."

I think this sounds fine.   Similarly, you may want to also mention that in order to create
a view successfully in SQL Authorization mode, the view owner needs to have the proper privileges
given to him/her if the underlying objects that the view references are not own by the view
owner.  e.g.:  if the authorization id user2 attempts to create a view called user2.v2 that
references table user1.t1 and function user1.f_abs().  user2 must have SELECT privilege on
user1.t1 and EXECUTE privilege on user1.f_abs().


CREATE VIEW user2.v2 as SELECT i, user1.f_abs(j) from user1.t1;

> Doc Review Updates - Ref Manual
> -------------------------------
>                 Key: DERBY-1839
>                 URL: http://issues.apache.org/jira/browse/DERBY-1839
>             Project: Derby
>          Issue Type: Improvement
>          Components: Documentation
>    Affects Versions:
>            Reporter: Laura Stewart
>         Assigned To: Laura Stewart
>         Attachments: 1839_SQLstatements.diff, derby1839_SQLstatements2.diff, derby1839_SQLstatements2_html.zip,
> This JIRA issue will be used to track all of the issues found in the 10.2 doc review
of the Reference Manual.

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


View raw message