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. Advertisements

  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. Advertisements

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,985
  2. =?Utf-8?B?S2Vu?=
    Replies:
    8
    Views:
    22,000
    blomm
    Jul 7, 2006
  3. Mike L.
    Replies:
    7
    Views:
    1,733
    Norman Yuan
    Jan 30, 2005
  4. casper
    Replies:
    0
    Views:
    9,257
    casper
    Apr 24, 2006
  5. Replies:
    0
    Views:
    970
  6. Jeff
    Replies:
    1
    Views:
    3,915
  7. casper

    CREATE DATABASE permission denied in database 'master'

    casper, Apr 24, 2006, in forum: ASP .Net Web Controls
    Replies:
    0
    Views:
    362
    casper
    Apr 24, 2006
  8. Prasath
    Replies:
    0
    Views:
    318
    Prasath
    Oct 14, 2004
Loading...