[
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="[email protected]"';
> ij> select CAST(schemaname AS VARCHAR(15)) AS SCHEMANAME,
> CAST (authorizationid AS VARCHAR(15)) AS AUTHORIZATIONID from sys.sysschemas;
> SCHEMANAME |AUTHORIZATIONID
> -------------------------------
> SYSIBM |[email protected]
> SYS |[email protected]
> SYSCAT |[email protected]
> SYSFUN |[email protected]
> SYSPROC |[email protected]
> SYSSTAT |[email protected]
> NULLID |[email protected]
> SQLJ |[email protected]
> SYSCS_DIAG |[email protected]
> SYSCS_UTIL |[email protected]
> APP |APP
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
