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 Thu, 11 Dec 2008 23:17: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-2.zip

Attaching DERBY-3193-2.diff, DERBY-3193-2.stat, and DERBY-3193-2.zip, updated versions of
the first patch that include changes to the Developer's Guide as well as a few tweaks to Reference
Manual topics.

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/devguide/cdevcsecure866060.dita
M      src/devguide/derbydev.ditamap
A      src/devguide/rdevcsecuresqlauthexceptions.dita
M      src/devguide/cdevcsecuregrantrevokeaccess.dita
M      src/devguide/cdevcsecure36595.dita
M      src/devguide/rdevcsecure379.dita
M      src/devguide/rdevcsecure190.dita
M      src/devguide/cdevcsecure865880.dita
A      src/devguide/cdevcsecureroles.dita
M      src/tools/rtoolsijcomrefshow.dita

I reorganized the Developer's Guide section as follows:

User authorizations
  Setting the default connection access mode
  Setting access for individual users
    Read-only and full access permissions
    User authorization exceptions
  Setting the SQL standard authorization mode
    Using SQL standard authorization
    Using SQL roles (new topic)
    SQL standard authorization exceptions (new topic)

Reordered bullet list in "User authorizations" (cdevcsecure36595.dita) to reflect this order.

Retitled "Setting the user authorizations for individual users" (cdevcsecure865880.dita) to
"Setting access for individual users".

Retitled "SQL standard authorization" (cdevcsecuregrantrevokeaccess.dita) to "Using SQL standard

Fixed a table in "Read-only and full access permissions" (rdevcsecure190.dita) so that empty
cells don't have single quote marks in them in the PDF and HTML-single versions.

Removed language specific to SQL authorization from "User authorization exceptions" (rdevcsecure379.dita).

Added new topics, cdevcsecureroles.dita and rdevcsecuresqlauthexceptions.dita.

Updated map file to reflect fixes (including reltable).


Additional fixes to the Reference Manual:

rrefsqljgrant.dita: only db owner can grant a role.

rrefsqljrevoke.dita: only db owner can revoke a role.

rrefsetrole.dita: setting role is not transactional; added examples.

rrefcreaterole.dita: just some typographical consistency fixes.

The Tools Guide topic is still lacking in content because I can't seem to get roles to work
right with current Derby trunk libraries. I set SQLAuthorization, but then I always get an
error when I try to set a role:

java -cp /home/chaase/derby10.5alpha/lib/derby.jar:. RoleExample
org.apache.derby.jdbc.EmbeddedDriver loaded.
Trying to connect to jdbc:derby:sqlAuthEmbDB;user=mary;create=true
Connected to database jdbc:derby:sqlAuthEmbDB;user=mary;create=true
Turning on authentication and SQL authorization.
Value of requireAuthentication is true
Value of sqlAuthorization is true
Value of defaultConnectionMode is noAccess

---SQLException Caught---

SQLState:   42Z60
Severity: 30000
Message:  CREATE ROLE not allowed unless database property derby.database.sqlAuthorization
has value 'TRUE'.

Same thing happened when I tried setting the properties on the ij command line and then doing

> 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:
>         Attachments: DERBY-3193-2.diff, DERBY-3193-2.stat, DERBY-3193-2.zip, 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.

View raw message