February 22, 2007 at 10:42 am
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!
February 23, 2007 at 8:34 am
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
February 23, 2007 at 10:00 am
Thanks - it certainly looks like a bug.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply