Database role and securables

• Paul Micklethwaite

  Mr or Mrs. 500

  Points: 512

  More actions

  February 22, 2007 at 10:42 am

  #171524

  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: 60524

  More actions

  February 23, 2007 at 8:34 am

  #691422

  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

  More actions

  February 23, 2007 at 10:00 am

  #691475

  Thanks - it certainly looks like a bug.