User with no permission Exception

Dec 9, 2016 at 3:04 PM
Edited Dec 9, 2016 at 3:05 PM
I get "UserWithNoPermissionException" with the following code even if I have access to the database. I am not sure what that means.
string _con = ConfigurationManager.ConnectionStrings["ConnectionStr"].ConnectionString;
        var mapper = new ModelToTableMapper<Account>();
        mapper.AddMapping(c => c.Id, "Id");
        mapper.AddMapping(c => c.Name, "Name");

        using (var dep = new SqlTableDependency<Account>(_con, "Account", mapper))
        {
            dep.OnChanged += Changed;
            dep.Start();

            Console.WriteLine("Press a key to exit");
            Console.ReadKey();

            dep.Stop();
        }
Dec 13, 2016 at 1:31 PM
Hello ramalladi,

please note that your current user needs some specific grants for SqlTableDependency to work correctly.

You can find the list of the required user grants at the following URL: https://tabledependency.codeplex.com/wikipage?title=SqlTableDependency