Edit view will lost privilege

Details

Description

Edit view will drop view first , then the privilege will lost

  1. File
    CODE_REVIEW.creview
    27/Nov/12 4:18 AM
    16 kB
    付雷
  1. grant1.png
    42 kB
    13/Dec/12 1:21 AM
  2. grant2.png
    79 kB
    13/Dec/12 1:21 AM
  3. grant3.png
    41 kB
    13/Dec/12 1:21 AM
  4. grant4.png
    42 kB
    13/Dec/12 1:21 AM

Activity

Ascending order - Click to sort in descending order
Hide
Permalink
付雷 (Inactive) added a comment -

Test step
1.grant some privilege of a view to a user
2.edit the view then check whether lost the privilege of the view

Show
付雷 (Inactive) added a comment - Test step 1.grant some privilege of a view to a user 2.edit the view then check whether lost the privilege of the view
Hide
Permalink
董志玲(Ella) added a comment - - edited

1.Add 'select,insert update alter' privilege of dzlview to user:dzl.
2.Delete one column of view:dzlview,then save
3.Check privilege of user:dzl,the user lose the privilege of dzlview.

So Edit view will lost privilege as bfore.

Show
董志玲(Ella) added a comment - - edited 1.Add 'select,insert update alter' privilege of dzlview to user:dzl. 2.Delete one column of view:dzlview,then save 3.Check privilege of user:dzl,the user lose the privilege of dzlview. So Edit view will lost privilege as bfore.
Hide
Permalink
付雷 (Inactive) added a comment -

Modify get old view privilege SQL

Show
付雷 (Inactive) added a comment - Modify get old view privilege SQL
Hide
Permalink
董志玲(Ella) added a comment -

Fixed in build 8.4.3.3054

Show
董志玲(Ella) added a comment - Fixed in build 8.4.3.3054

People

  • Assignee:
    董志玲(Ella)
    Reporter:
    付雷 (Inactive)
Vote (0)
Watch (2)

Dates

  • Created:
    Updated:
    Resolved: