Database role and securables

  • Paul Micklethwaite

    Mr or Mrs. 500

    Points: 512

    Hi, this seems very basic so I think I must be missing something somewhere! I've created a new database role (thru Management Studio) in MSDB and given the role execute permission on a number of stored procedures and SELECT on one table. Then assigned users to the database role. Tested that permissions work okay by doing a query on the table - all well and good.

    However, when I go back to view the database role properties there is nothing listed under Securables so I can't modify or remove the ones I set previously. Help!

     

  • EdVassie

    SSC Guru

    Points: 60272

    Try a Google search.  I think this is a known bug.  The permissions are set but the dialogue does not show them.  You can maintain the permissions using GRANT, DROP, etc queries in SSMS.

    I have not tried SP2 yet, but I believe the problem should be fixed in SP2

    Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.

    When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara

  • Paul Micklethwaite

    Mr or Mrs. 500

    Points: 512

    Thanks - it certainly looks like a bug.

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply