Address remaining upgrade task(s) to complete full upgrade mechanism for
GRANT/REVOKE, specifically with changing database owner name from 'DBA' to
authorizationId of user invoking upgrade.
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Key: DERBY-1544
URL: http://issues.apache.org/jira/browse/DERBY-1544
Project: Derby
Issue Type: Sub-task
Components: SQL
Affects Versions: 10.2.0.0
Environment: generic
Reporter: Satheesh Bandaram
Fix For: 10.2.0.0
Upgrading a database from 10.1 to 10.2 should automatically change database
owner, recorded as owner of system schemas in sysschemas, from pseudo user
'DBA' to authorizationID of the user attempting upgrade.
Another upgrade change I am thinking about is to grant execute privilege to 5
system routines that by default have execute privilege to public when a new
database is created. Five system routines, two compress routines and three
statistics related routines are given execute privilege to public when a new
10.2 database is created. This is not done when a 10.1 database is upgraded to
10.2 and probably good to include these privileges during database upgrade.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
