You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@trafodion.apache.org by "Alice Chen (JIRA)" <ji...@apache.org> on 2015/07/22 20:20:23 UTC

[jira] [Created] (TRAFODION-1199) LP Bug: 1447330 - DB__ROOT required to revoke object and column privileges granted by other users

Alice Chen created TRAFODION-1199:
-------------------------------------

             Summary: LP Bug: 1447330 - DB__ROOT required to revoke object and column privileges granted by other users
                 Key: TRAFODION-1199
                 URL: https://issues.apache.org/jira/browse/TRAFODION-1199
             Project: Apache Trafodion
          Issue Type: Bug
          Components: sql-security
            Reporter: Cliff Gray
            Assignee: Cliff Gray
            Priority: Critical
             Fix For: 2.0-incubating


DBAs cannot manage object and column grants performed by other users.  A component privilege is needed to allow an administrator to manage granted privileges at the object and column level.

E.g.

REVOKE SELECT ON Table1 FROM User1 GRANTED BY User2;

There needs to be a method for a user/role to be granted the authority to perform this operation.  Currently restricted to DB__ROOT.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)