sql program in win form in c#

Question

0.00/5 (No votes)

See more:

Hi all
I am beginner programmer I write a program and my program connect to the data base
with connection string but in my program appearance this error

The INSERT permission was denied on the object 'table name', database 'database name ', schema 'dbo'.
How to get permission to access table in data base ?
Do I change my code or my data base to solve this problem?

Posted 8-Aug-11 20:54pm

lilipoot 100

Add a Solution

5 solutions

Solution 1

Hi,

you must change the permissions in the database-system.
The user you connect with, havent the permissions to change, update, ... the data.

Posted 8-Aug-11 20:56pm

`Thomas W.

Comments

`Thomas W. 10-Aug-11 3:39am

If you have the right permissions for the user you connect with, something is wrong with the connectionstring.
I think your information about the databasename and/or tablename are wrong.
In your Errormessage you write you haven't the permission for schema 'dbo' but you said your databasename/ chema is 'store'.

Check or post your connectionstring to find the fault.

Solution 2

1) Go to your database and right click on the table.
2) Select properties then a small window will appear
3) Select Permission from the right side
4) Select the User/Role and give the access by checking the checkbox.

Posted 8-Aug-11 21:02pm

Toniyo Jackson

Comments

lilipoot 100 9-Aug-11 3:10am

I do this order in my data base but having that error yet.

Solution 3

This may sound silly, but have you got a table called 'table name' and a database called 'database name' if you have fine. But to me sounds like you haven't named them properly. Could you post your connection string please?

Posted 8-Aug-11 21:47pm

DanHodgson88

Comments

lilipoot 100 9-Aug-11 5:25am

my table and my data base have names
my database name is store and my table name foroshandegan

Solution 4

You dont have permission in SQLSERVER to insert any records for that particluar database. either change the sql connection string with the user credentials whose got insert promissions.(eg sa)

Posted 8-Aug-11 22:02pm

Syed Salman Raza Zaidi

Comments

lilipoot 100 9-Aug-11 5:28am

please explain your solution because my program connect to the database but i
don't insert,delete,...and what is meaning of (eg sa)

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)

lilipoot 100 · Accepted Answer · 2011-08-09T20:09:00

Solution 6

I should owner in data base
security.login.select user. select database.in user mapping
select owner

Posted 9-Aug-11 20:09pm

lilipoot 100