db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Kim Haase (Updated) (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (DERBY-5522) Document the NATIVE authentication scheme.
Date Fri, 09 Mar 2012 22:30:57 GMT

     [ 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
            "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
> 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:
>            Reporter: Rick Hillegas
>            Assignee: Kim Haase
>         Attachments: 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


View raw message