A big problem about sql help

Question

0.00/5 (No votes)

See more:

Hi all
I have a big problem when I want to insert row in my data grid view and click insert button this error appearance :
The INSERT permission was denied on the object 'table name', database 'database name', schema 'dbo'.
what do I do?

Posted 8-Aug-11 19:06pm

lilipoot 100

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

thatraja · Answer 1 · 2011-08-08T19:12:00

Solution 1

As the error says you don't have permission for that table so you need to give permission for access.
Ask your database administrator or read this

GRANT Object Permissions (Transact-SQL)[^]

Posted 8-Aug-11 19:12pm

thatraja

Comments

walterhevedeich 9-Aug-11 1:14am

Correct.

lilipoot 100 9-Aug-11 1:30am

thanks
I read it but I don't understand compeletly

lilipoot 100 9-Aug-11 2:23am

How do I give permission for access?

thatraja 9-Aug-11 2:34am

You need to execute appropriate SQL commands for that. Read the documentation slowly. In that page you can find the below one
The following example grants SELECT permission to user RosaQdM on table Person.Address in the AdventureWorks database.

USE AdventureWorks;
GRANT SELECT ON OBJECT::Person.Address TO RosaQdM;
GO

If you are not familiar with these things please ask your database administrator or someone to help you.