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.
