#820 Menus with extra permissions (1.3.x)

1.3
closed-fixed
menu (1)
5
2013-05-16
2013-05-13
No

Via email

Turns out that four additional, out-of-the-box entries were also deleted when running this SQL:

delete from menu_acl where node_id in (select node_id from menu_attribute where attribute = 'menu');

(from Brian Wolf)

Discussion

  • Chris Travers

    Chris Travers - 2013-05-13

    mtech_test=# select * from menu_acl where node_id in (select node_id from menu_attribute where attribute = 'menu');
    id | role_name | acl_type | node_id
    ------+----------------------------------------------+----------+---------
    8262 | lsmb_mtech_testorders_purchase_consolidate | allow | 60
    8264 | lsmb_mtech_test
    orders_sales_consolidate | allow | 60
    8354 | public | allow | 192
    (3 rows)

    mtech_test=# select * from menu_node where id in (select node_id from menu_acl where node_id in (select node_id from menu_attribute where attribute = 'menu'));
    id | label | parent | position
    -----+-------------+--------+----------
    60 | Consolidate | 50 | 5
    192 | New Window | 0 | 22
    (2 rows)

    That new window entry seems fishy to me. The other acls are safe to delete.

     
  • Chris Travers

    Chris Travers - 2013-05-16

    svn 5804

     
  • Chris Travers

    Chris Travers - 2013-05-16
    • status: open --> closed-fixed
    • assigned_to: Chris Travers
     

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:

JavaScript is required for this form.





No, thanks