| Author |
Topic |
|
aspnewbb
Starting Member
31 Posts |
 Posted - 2006-08-18 : 07:52:11
|
| I used Enterprise Manager to create a database, and a table to hold contact form data (so I can remember what someone original sends me... im old ;)I added a use to the new database and gave him every permission i check...then i went and created the form to do the insert but when i press submit I get this error:"Microsoft OLE DB Provider for SQL Server error '80040e09' INSERT permission denied on object 'b2Request', database 'b2', owner 'dbo'. request.asp, line 122 "I read somewhere (yes i google before i post) that i need to add the machien as a user? UISR_blahIs this the case and how do I accomplish it (remeber im a newb, please)? |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2006-08-18 : 08:29:02
|
| You need to know how the user is connecting.If you have given the user you expect insert permission on the table then it probably means you are not connecting with the user you expect.Try select user_name() on the connection and see what it says.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
aspnewbb
Starting Member
31 Posts |
Posted - 2006-08-18 : 08:38:48
|
| It shows the correct user (the one i created) |
|
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2006-08-18 : 08:54:38
|
| then rungrant insert on dbo.b2Request to myuserand try again.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
aspnewbb
Starting Member
31 Posts |
Posted - 2006-08-18 : 09:08:43
|
| still getting the same errorMicrosoft OLE DB Provider for SQL Server error '80040e09' INSERT permission denied on object 'b2Request', database 'b2', owner 'dbo'. I am not sure what it could be...did what I said about making the machine a user make any sense to anyone? IUSR_ something_somehow |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2006-08-18 : 09:14:03
|
| Does MyUser have a empty/blank password?Is database b2 set to READ-ONLY?See this topic [url]http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=53622[/url].Peter LarssonHelsingborg, Sweden |
|
|
|
aspnewbb
Starting Member
31 Posts |
Posted - 2006-08-18 : 09:22:14
|
| The user has a name and passwordalso i checked the file itself and permissions and they are not read only (good guess tho :) |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2006-08-18 : 09:24:10
|
| What roles does MyUser has? DATA_READER? dbo?Peter LarssonHelsingborg, Sweden |
|
|
|
aspnewbb
Starting Member
31 Posts |
Posted - 2006-08-18 : 09:29:19
|
| I checked em all :)owner/admin/ all of em |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2006-08-18 : 09:31:54
|
| If MyUser has SystemAdministrator role or is dbo of database b2, then something terribly wrong must have happened, since he has no insert rights on table b2request.Post line 122 so we can se what you are trying to do against the database.Peter LarssonHelsingborg, Sweden |
|
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2006-08-18 : 09:34:48
|
| >> I checked em all :)Including denydatawriter?==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
aspnewbb
Starting Member
31 Posts |
Posted - 2006-08-18 : 09:39:08
|
| omg your right... this is why i shoudl never try anything without having my coffee firstthanks everysorry to be such a pita.. but i learned soemthing today :) |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2006-08-18 : 09:45:56
|
| My bad. I believed you when you told us you checked them all...Peter LarssonHelsingborg, Sweden |
|
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2006-08-18 : 09:57:22
|
| I think that was "checked" as in "set them all on".Can mean that or looked at them.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2006-08-18 : 10:04:56
|
Oh. I interpreted it as he had "confirmed/looked" that the needed rights were in place. I didn't realize he meant "all of them" were in place  That what happens when english is not first language.Peter LarssonHelsingborg, Sweden |
|
|
|
aspnewbb
Starting Member
31 Posts |
Posted - 2006-08-18 : 10:46:05
|
| I take full blame,Thank you guys so much for helping |
|
|
|
stephenbaer
Yak Posting Veteran
71 Posts |
Posted - 2006-08-29 : 21:45:29
|
| Hey, speaking of the "INSERT permission denied on..." message, does anyone know how to trap this error (and the corresponding UPDATE denied message) and assign to it a more user-friendly message in an Access ADP front end? Something like, "The current user does not have permission to add or change a record in this table." I know this isn't the Access forum...but you know how it is...----------------------------------------------------------------------------------------------Gary Getsum: What happened to my mule?DM: It's dead; It got stung by a giant wasp. Gary: Can't I heal it?DM: I'm sorry, I know you were fond of the mule, but it just got attacked by a wasp the size of a Volkswagen!Gary: So?DM: Dude, look- you're going to have to carry all your own treasure now... Your mule gives new meaning to the term "Puff Daddy". |
|
|
|
|
INSERT permission denied