The result for select user_name(), current_name
in [ASP .NET]
|
Prev: I published and a folder that was empty did not get copied to the host
Next: HTML reader on secure site
From: Tony Johansson on 6 Jan 2010 18:47 Hello! If I use suser_sname in my program and use IIS I get hempc\aspnet. Now to my question. If I use select user_name(), current_name I get dbo. For example if the result for this select user_name(), current_name should be aspnet how should the settings be configured then.'' //Tony
From: Alexey Smirnov on 7 Jan 2010 03:14 On Jan 7, 12:47 am, "Tony Johansson" <johansson.anders...(a)telia.com> wrote: > Hello! > > If I use suser_sname in my program and use IIS I get > hempc\aspnet. > > Now to my question. > If I use select user_name(), current_name I get dbo. > For example if the result for this select user_name(), current_name > should be aspnet how should the settings be configured then.'' > > //Tony Can you please explain more about your application setup? Is this about Oracle or ASP.NET?
From: Tony Johansson on 7 Jan 2010 04:41 I run a webb site using asp.net and the database I use is a SQL Server express 2005 //Tony "Alexey Smirnov" <alexey.smirnov(a)gmail.com> skrev i meddelandet news:7f982bc2-2ab3-4ee3-9c06-43e35d07a0cc(a)m16g2000yqc.googlegroups.com... On Jan 7, 12:47 am, "Tony Johansson" <johansson.anders...(a)telia.com> wrote: > Hello! > > If I use suser_sname in my program and use IIS I get > hempc\aspnet. > > Now to my question. > If I use select user_name(), current_name I get dbo. > For example if the result for this select user_name(), current_name > should be aspnet how should the settings be configured then.'' > > //Tony Can you please explain more about your application setup? Is this about Oracle or ASP.NET?
From: Alexey Smirnov on 7 Jan 2010 05:06
On Jan 7, 10:41 am, "Tony Johansson" <johansson.anders...(a)telia.com> wrote: > I run a webb site using asp.net and the database I use is a SQL Server > express 2005 > > //Tony > > "Alexey Smirnov" <alexey.smir...(a)gmail.com> skrev i meddelandetnews:7f982bc2-2ab3-4ee3-9c06-43e35d07a0cc(a)m16g2000yqc.googlegroups.com... > On Jan 7, 12:47 am, "Tony Johansson" <johansson.anders...(a)telia.com> > wrote: > > > Hello! > > > If I use suser_sname in my program and use IIS I get > > hempc\aspnet. > > > Now to my question. > > If I use select user_name(), current_name I get dbo. > > For example if the result for this select user_name(), current_name > > should be aspnet how should the settings be configured then.'' > > > //Tony > > Can you please explain more about your application setup? > Is this about Oracle or ASP.NET? Ok, so how do you get hempc\aspnet and dbo? I supposed you try to get authenticated against SQL Server, but it's still not clear what you did and what you want to get. Is it possible to see some code of your program? Thanks |