[jira] Updated: (DERBY-3193) SQL roles: Add documentation

["Kim Haase (JIRA)" <ji...@apache.org>]

     [ 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.