December 2, 2008 at 9:37 am
Hi all,
when I try to add securables to a database role (e.g. allowing only users of a certain user defined database role to access tables within a certain scheme) those securables dissapear once i press OK and reopen the properties of the specific database role.
Does anyone have a solution for this problem?
Thanks!
JM
December 2, 2008 at 10:09 am
Can you provide a more detailed example of what you are doing and what happens?
[font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]
September 22, 2011 at 6:21 am
I have this same problem. I can run a script that grants execute for the stored procedure to the role, or I can manually add the permissions through the gui(securables). Either way, when I look in the gui, those permissions do not show up under the securables. However, if I run "sp_helprotect @username='Role_Name' " It returns the permissions that I granted earlier. For some reason, it's still not showing up in the gui.
This particular instance is version 9.0.4035.
April 13, 2016 at 11:29 am
Check out the suggestions people gave me on my post about the same issue and see if anything helps you. Nothing has resolved my issue so far, but I believe it's because one of my roles will automatically be added if the user is granted a different role. I haven't been able to track down what is causing that to happen, but I'm currently looking into it.
http://www.sqlservercentral.com/Forums/Topic1776987-3411-1.aspx
Thanks,
JimiHaze
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply