Details
-
Bug
-
Status: Open
-
Minor
-
Resolution: Unresolved
-
10.2.2.0
-
None
-
Low
-
Repro attached
Description
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