[
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
DERBY-3193-2.stat
DERBY-3193-2.diff
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 authorization".
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 CREATE ROLE there.
> 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-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.
