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 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy