Uploaded image for project: 'Apache Trafodion'
  1. Apache Trafodion
  2. TRAFODION-1773

internal error to revoke role with restrict option when there is dependent views

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 2.0-incubating
    • Fix Version/s: None
    • Component/s: sql-security
    • Labels:
      None

      Description

      When processing through the list of dependencies, the code does not assum dependent views.

      Reproduce steps –

      user dbroot--
      create role rp_a22role1;
      create role rp_a22role2;
      grant role rp_a22role1,rp_a22role2 to testuser3;
      create shared schema mysch_share;
      set schema mysch_share;
      create table a22tab1(a1 int not null primary key, b1 varchar(10));
      create table a22tab2(a2 int ,b2 varchar(10))no partition;
      create view a22v1 as select * from a22tab1;
      grant select on a22tab2 to rp_a22role1;
      grant select on a22v1 to rp_a22role2 ;

      user testuser3--

      set schema mysch_share;
      create view a22v3(col1,col2) as select b1,b2 from a22v1,a22tab2 where a1=a2;

      user dbroot--

      set schema mysch_share;
      revoke role rp_a22role1 from testuser3 ;

          • ERROR[1364] Cannot revoke role RP_A22ROLE1. Object TRAFODION.MY_SCHEMA22.A22V3 depends on privileges on object TRAFODION.MY_SCHEMA22.A22TAB2. [2016-01-14 06:13:11]

      revoke role rp_a22role2 from testuser3 restrict; // Rachel: should get ERROR[1364] too

          • ERROR[1001] An internal error occurred in module ../sqlcomp/PrivMgrRoles.cpp on line 421. DETAILS(Unrecognized PrivType). [2016-01-14 06:13:11]

        Attachments

          Activity

            People

            • Assignee:
              rmarton Roberta Marton
              Reporter:
              rachelgao Gao, Rui-Xian
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: