[ 
https://issues.apache.org/jira/browse/DERBY-3193?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Kim Haase updated DERBY-3193:
-----------------------------

    Attachment: DERBY-3193.zip
                DERBY-3193.stat
                DERBY-3193.diff

I've made the needed changes to the Reference Manual and Tools Guide, I 
believe, so I'm providing an initial patch for this material: see 
DERBY-3193.diff, DERBY-3193.stat, and DERBY-3193.zip. The changes are as 
follows:

M      src/ref/crefsqlj35312.dita
A      src/ref/rrefcurrentrole.dita
A      src/ref/rrefcreaterole.dita
A      src/ref/rrefsetrole.dita
M      src/ref/rrefsqljrevoke.dita
M      src/ref/crefsqlj80721.dita
A      src/ref/rrefrolename.dita
M      src/ref/rrefsistabssystableperms.dita
A      src/ref/rrefsistabssysroles.dita
M      src/ref/rrefsyscsdiagtables.dita
M      src/ref/crefsqlj95081.dita
M      src/ref/rrefsistabssysroutineperms.dita
A      src/ref/rrefdroprole.dita
M      src/ref/rrefsistabssyscolperms.dita
M      src/ref/rrefsqlj30540.dita
M      src/ref/rrefsqlj31580.dita
M      src/ref/rrefsqljgrant.dita
M      src/ref/refderby.ditamap
M      src/tools/rtoolsijcomrefshow.dita

The Developer's Guide, where the overall conceptual material belongs, is a bit 
harder to work with. The new material belongs under the "User authorizations" 
section, I believe. However, the section seems also to need some 
reorganization. The sections "Setting the default connection mode" and its 
subsection "Setting the user authorizations for individual users" are currently 
under "Setting the SQL standard authorization mode", but aren't they 
independent of SQL authorization? I think you can use the builtin user 
authorizations independent of SQL authorization.

The general "User authorizations" topic lists the properties in this order:

  derby.database.defaultConnectionMode
  derby.database.sqlAuthorization
  derby.database.fullAccessUsers, derby.database.readOnlyAccessUsers

So it might be better to organize this section as follows:

User authorizations
  Setting the default connection access mode
  Setting the SQL standard authorization mode
    SQL standard authorization (retitle as "Using SQL standard authorization")
  Setting the user authorizations for individual users
    Read-only and full access permissions
  User authorization exceptions

Does this make sense?

The additional conceptual information on roles belongs in "Using SQL standard 
authorization", I think. I'll work on adding it.


> SQL roles: Add documentation
> ----------------------------
>
>                 Key: DERBY-3193
>                 URL: https://issues.apache.org/jira/browse/DERBY-3193
>             Project: Derby
>          Issue Type: Task
>          Components: Documentation
>            Reporter: Dag H. Wanvik
>            Assignee: Kim Haase
>             Fix For: 10.5.0.0
>
>         Attachments: DERBY-3193.diff, DERBY-3193.stat, DERBY-3193.zip, 
> derby3193-tmp.diff, derby3193-tmp.stat
>
>


-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.

Reply via email to