August 1, 2010 at 1:48 am
Hii everyone,
I am new to T SQL and Service Broker. I am unable to grant a create message type permission successfully.
1.First I grant create message type permission to my user
2.Second I deny create message type permission to my user
3.I repeat 1.
4.I grant alter any message type to my user
5.i deny alter any message type to my user
6.Second I deny create message type permission to my user
7.I repeat 1.
What am i supposed to do to succesfully grant create message type permission.
Thanks in advance...
August 1, 2010 at 5:05 am
I am a newbie too....veterans guide me if i'm wrong
Grant 'ALTER ANY' message type to the user and your user will then be able to create, alter or drop message type (this should resolve your issue and allow your user to create message type).
Once 'Alter any' permission is 'deny'ied you cannot grant create message type (you can but eventually they dont work as in your case).
Next time when you need to issue alter permission to your user use
GRANT ALTER ON MESSAGE TYPE::'message_type' TO ;
instead of alter any
hope this will resolve the issue....
August 2, 2010 at 12:27 am
resolved....thank you so much....
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply