Velocity Reviews - Computer Hardware Reviews

Velocity Reviews > Newsgroups > Programming > ASP .Net > EXECUTE permission denied on object 'getUniqueCities', database 'd

Thread Tools

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

Posts: n/a
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"

Reply With Quote
Jason Bentley
Posts: n/a
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

Reply With Quote

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
EXECUTE permission denied on object... uh? Jiggaz ASP .Net 9 02-17-2014 05:14 AM
EXECUTE permission denied on object 'aspnet_CheckSchemaVersion Jeff ASP .Net 1 03-06-2008 04:09 PM
EXECUTE permission denied on object 'sp_sdidebug', database 'maste =?Utf-8?B?S2Vu?= ASP .Net 8 07-07-2006 02:22 PM
CREATE DATABASE permission denied in database 'master' casper ASP .Net 0 04-24-2006 02:41 PM
Create and Execute Procedure Permission denied in database 'dbxxx' Prasath ASP .Net Web Services 0 10-14-2004 10:53 AM