Clone
Cliff Gray <cliff.gray@hp.com>
committed
on 09 Jun 15
Security bug fixes
Corrects a number of bugs in security and SQL DDL.
1. 1439316: Internal error when creating view with sequence.
2. 144182… Show more
Security bug fixes

Corrects a number of bugs in security and SQL DDL.

1. 1439316: Internal error when creating view with sequence.

2. 1441825: User in role-owned schema is not given grant option.

3. 1447328: DB__ROOT required to revoke component privileges

  by other users.

4. 1447330: DB__ROOT required to revoke object and

  column privileges granted by other users.

In addition, Launchpad bugs 1350627 and 1438886 were tested and

found to no longer be a defect.

Two new component-level privileges were added, MANAGE and

MANAGE_PRIVILEGES.

Users who have the MANAGE_PRIVILEGE component-level privilege can

grant and revoke privileges at the schema, object, and column

level on behalf of other users and roles.  Users who have the

MANAGE_PRIVILEGE component-level privilege can also grant

"WITH GRANT OPTION" any privilege they have.

A user granted the MANAGE privilege has all the MANAGE_* privileges,

which includes MANAGE_COMPONENTS, MANAGE_LIBRARY, MANAGE_LOAD,

MANAGE_PRIVILEGES, MANAGE_ROLES, MANAGE_STATISTICS, and MANAGE_USERS.

Change-Id: I10873de95f75114b937e1144f3af9aba76884eae

Show less

default + 8 more