Which permission I should give to an mssql user to be able to request the Query notifications?
Posted on 2010-01-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?