db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Tiago R. Espinha (JIRA)" <j...@apache.org>
Subject [jira] Updated: (DERBY-3339) APP schema is always owned by APP regardless of the database owner
Date Mon, 13 Jul 2009 12:51:15 GMT

     [ https://issues.apache.org/jira/browse/DERBY-3339?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Tiago R. Espinha updated DERBY-3339:
------------------------------------

    Issue & fix info: [Repro attached]
             Urgency: Low

Triaged for 10.5.2.

Assigned low urgency and repro attached.

> APP schema is always owned by APP regardless of the database owner
> ------------------------------------------------------------------
>
>                 Key: DERBY-3339
>                 URL: https://issues.apache.org/jira/browse/DERBY-3339
>             Project: Derby
>          Issue Type: Bug
>          Components: SQL
>            Reporter: Daniel John Debrunner
>            Priority: Minor
>
> Every schema in a newly created database should be owned by the database owner since
APP may not be a valid user.
> ij> connect 'jdbc:derby:cs;create=true;user="djd@acme.org"';
> ij> select CAST(schemaname AS VARCHAR(15)) AS SCHEMANAME,
> CAST (authorizationid AS VARCHAR(15)) AS AUTHORIZATIONID from sys.sysschemas;
> SCHEMANAME     |AUTHORIZATIONID
> -------------------------------
> SYSIBM         |djd@acme.org
> SYS            |djd@acme.org
> SYSCAT         |djd@acme.org
> SYSFUN         |djd@acme.org
> SYSPROC        |djd@acme.org
> SYSSTAT        |djd@acme.org
> NULLID         |djd@acme.org
> SQLJ           |djd@acme.org
> SYSCS_DIAG     |djd@acme.org
> SYSCS_UTIL     |djd@acme.org
> APP            |APP

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