[
https://issues.apache.org/jira/browse/DERBY-5522?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Kim Haase updated DERBY-5522:
-----------------------------
Attachment: NativeAuthExampleEmbedded.java
Hm, this is odd. I turn on NATIVE authentication and then try to create some
roles:
// Set authentication scheme to Derby NATIVE
System.out.println(
"Turning on NATIVE authentication.");
s.executeUpdate(setProperty + provider + ", 'NATIVE::LOCAL')");
s.executeUpdate("CREATE ROLE ADDER");
s.executeUpdate("CREATE ROLE USER");
s.executeUpdate("GRANT ADDER TO sqlsam");
s.executeUpdate("GRANT USER TO guest, mary");
But I get this error:
java -cp /export/home/chaase/javadbmore/codetrunk/trunk/jars/insane/derby.jar:.
NativeAuthExampleEmbedded
Trying to connect to jdbc:derby:nativeAuthEmbDB;user=sysadm;create=true
Connected to database jdbc:derby:nativeAuthEmbDB;user=sysadm;create=true
Storing some sample users in the database.
Turning on NATIVE authentication.
---SQLException Caught---
SQLState: 42Z60
Severity: 30000
Message: CREATE ROLE not allowed unless database property
derby.database.sqlAuthorization has value 'TRUE'.
So apparently behaving "as if" derby.database.sqlAuthorization is set isn't
good enough for CREATE ROLE?
> Document the NATIVE authentication scheme.
> ------------------------------------------
>
> Key: DERBY-5522
> URL: https://issues.apache.org/jira/browse/DERBY-5522
> Project: Derby
> Issue Type: Improvement
> Components: Documentation
> Affects Versions: 10.9.0.0
> Reporter: Rick Hillegas
> Assignee: Kim Haase
> Attachments: NativeAuthExampleEmbedded.java,
> NativeAuthExampleEmbedded.java, NativeAuthExampleEmbedded.java
>
>
> We should document NATIVE authentication after we have implemented the
> changes described on DERBY-866. The documentation changes are described by
> the functional spec UserManagement.html attached to that issue.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators:
https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira
