EXECUTE permission denied on object 'getUniqueCities', database 'd

Discussion in 'ASP .Net' started by =?Utf-8?B?ZGF2aWQ=?=, Mar 28, 2005.

  1. I am using MS ASP.NET course matrial in Model 16.
    I have the above problem.
    I have setup user machin\ASPNET as Reeder and Writer for doctors database
    More informatin are in following
    System.Data.SqlClient.SqlException: EXECUTE permission denied on object
    'getUniqueCities', database 'doctors', owner 'dbo'

    Source Error:


    Line 255: SqlConnection1.Open()
    Line 256: Dim drCities As SqlDataReader
    Line 257: drCities = cmdCities.ExecuteReader()
    Line 258: lstCities.DataSource = drCities
    Line 259: lstCities.DataTextField = "City"
     
    =?Utf-8?B?ZGF2aWQ=?=, Mar 28, 2005
    #1
    1. Advertising

  2. David, your error is your answer. Whatever context the connection is
    executing in does not have execution permission on getUniqueCities.
    Give us some details about your SqlConnection object and your os, etc.

    Jason Bentley
    http://geekswithblogs.net/jbentley
     
    Jason Bentley, Mar 28, 2005
    #2
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Jiggaz
    Replies:
    9
    Views:
    21,235
  2. =?Utf-8?B?S2Vu?=
    Replies:
    8
    Views:
    21,483
    blomm
    Jul 7, 2006
  3. casper
    Replies:
    0
    Views:
    9,100
    casper
    Apr 24, 2006
  4. Jeff
    Replies:
    1
    Views:
    3,751
  5. Prasath
    Replies:
    0
    Views:
    194
    Prasath
    Oct 14, 2004
Loading...

Share This Page