Explicit Permission not visible after save

• tripower

  SSCrazy

  Points: 2035

  More actions

  December 3, 2009 at 12:56 pm

  #213154

  After going into the Securables | Explicit Permissions for my db Role I see that all of the explicit permissions that I have previously set for all of my database objects are no longer visible and when I reselect the objects for my schema none of my selections is selected. What kind of UI is this and how can this possibly be useful for setting and re-setting object permissions? And how do I get this to display object permissions?

• tan110

  Hall of Fame

  Points: 3855

  More actions

  September 16, 2021 at 5:38 pm

  #3930255

  I'm running into the same issue for SQL Server 2016. Does anyone have a solution for this?