Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Which permission I should give to an mssql user to be able to request the Query notifications?

Posted on 2010-01-08
2
Medium Priority
?
562 Views
Last Modified: 2012-05-08
I have user Web1 in the MSSQL database, i went to the Manager opened
Security > Logins > right clicked on user Web1 and in User Mapping i made this user dbo for database DB1.

And i gave db_public , db_datawritter, db_datareader

I got this error: User "Web1" does not have permission to request query notification subscriptions on database "DB1".

This issue is solved only if i set the user to db_owner.

Is there any other way to be fixed without having the user as db_owner?


Thanks


0
Comment
Question by:roland206
2 Comments
 
LVL 9

Accepted Solution

by:
selva_kongu earned 2000 total points
ID: 26208948
Use SUBSCRIBE QUERY NOTIFICATIONS permission.

0
 

Author Comment

by:roland206
ID: 26209038
Selva thanks a lot

I did

GRANT SUBSCRIBE QUERY NOTIFICATIONS TO Web1
GRANT RECEIVE ON QueryNotificationErrorsQueue TO Web1

and worked like a charm.

Thanks
0

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article, we’ll look at how to deploy ProxySQL.
Creating a Cordova application which allow user to save to/load from his Dropbox account the application database.
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …

578 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question