writing permission on SQL server

[eranby]

Hi,
I connect the SQL server in my application using this code :
ConnectionStrin gSettings settings =
ConfigurationMa nager.Connectio nStrings["StockDB"];
con = new SqlConnection(s ettings.Connect ionString);
but I have no writing permission the database is for read only what should I do in order to add writing permission?
thanks
Eran

[kenobewan]

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...

[eranby]

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

[Frinavale]

I've moved the question to the MS SQL Server forum.

-Frinny

[eranby]

I need to connect to the sever and write to it from the c# application can the help me with that??

[ck9663]

Call your system administrator to give you the necessary rights.


-- CK

[eranby]

this application is on my on pc, there are no administrators involved

[ck9663]

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