You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-dev@db.apache.org by "Daniel John Debrunner (JIRA)" <ji...@apache.org> on 2008/01/22 00:38:34 UTC
[jira] Created: (DERBY-3339) APP schema is always owned by APP
regardless of the database owner
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.
[jira] Updated: (DERBY-3339) APP schema is always owned by APP
regardless of the database owner
Posted by "Tiago R. Espinha (JIRA)" <ji...@apache.org>.
[ 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.