By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,842 Members | 2,368 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,842 IT Pros & Developers. It's quick & easy.

writing permission on SQL server

P: 17
Hi,
I connect the SQL server in my application using this code :
ConnectionStringSettings settings =
ConfigurationManager.ConnectionStrings["StockDB"];
con = new SqlConnection(settings.ConnectionString);
but I have no writing permission the database is for read only what should I do in order to add writing permission?
thanks
Eran
Nov 2 '08 #1
Share this Question
Share on Google+
7 Replies


kenobewan
Expert 2.5K+
P: 4,871
Connect through an admin account or upgrade your log in or add user account with appropriate permission or create a SP with the right permissions or impersonate the dbo account??? Bit strange, having read only access to a DB...
Nov 3 '08 #2

P: 17
mmm.. I guess there are many solutions , but I'm new to SQL server and the default permission is read only , I have searched a lot for an answer and didn't find any ,may you guide me how to implement one of those solutions ??

Thanks
Eran
Nov 3 '08 #3

Frinavale
Expert Mod 5K+
P: 9,731
I've moved the question to the MS SQL Server forum.

-Frinny
Nov 3 '08 #4

P: 17
I need to connect to the sever and write to it from the c# application can the help me with that??
Nov 3 '08 #5

ck9663
Expert 2.5K+
P: 2,878
Call your system administrator to give you the necessary rights.


-- CK
Nov 4 '08 #6

P: 17
this application is on my on pc, there are no administrators involved
Nov 4 '08 #7

ck9663
Expert 2.5K+
P: 2,878
Where did your database come from and why don't you have the necessary rights on your own db? Login using the sa account, then.


-- CK
Nov 5 '08 #8

Post your reply

Sign in to post your reply or Sign up for a free account.