468,242 Members | 1,496 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,242 developers. It's quick & easy.

writing permission on SQL server

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
7 1516
kenobewan
4,871 Expert 4TB
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
eranby
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
9,735 Expert Mod 8TB
I've moved the question to the MS SQL Server forum.

-Frinny
Nov 3 '08 #4
eranby
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
2,878 Expert 2GB
Call your system administrator to give you the necessary rights.


-- CK
Nov 4 '08 #6
eranby
17
this application is on my on pc, there are no administrators involved
Nov 4 '08 #7
ck9663
2,878 Expert 2GB
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.

Similar topics

12 posts views Thread by Russ | last post: by
2 posts views Thread by Taishi | last post: by
reply views Thread by Gazelle | last post: by
6 posts views Thread by MattC | last post: by
7 posts views Thread by Mike L. | last post: by
2 posts views Thread by MattB | last post: by
2 posts views Thread by =?Utf-8?B?REo=?= | last post: by
reply views Thread by NPC403 | last post: by
reply views Thread by kermitthefrogpy | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.