db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Kim Haase (JIRA)" <j...@apache.org>
Subject [jira] Updated: (DERBY-3193) SQL roles: Add documentation
Date Tue, 25 Nov 2008 18:13:44 GMT

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


Mime
View raw message