|
|
|||||||||
|
|||||||||
|
|||||||||
| |
|||
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Display Modes |
|
#1
|
|||
|
|||
|
Windows Authentication
Hi,
I am trying to work on a security related issue with SQL server. I am trying to connect to sql server with windows authentication. It connects me fine and when I do a 'select user_name()', it returns 'dbo'. I am not sure how a database user is being associated to when I use windows authentication, as there is no database login or user created with my windows name. Still it shows me as 'dbo' when I connect with my windows login (to query analyzer). Help in understanding this would be greatly appreciated. Thanks Raj |
|
#2
|
||||
|
||||
|
If you are accessing the DB through a webpage, then yes, the info you are getting back would be correct. Take a look at your connection string to the DB (sounds like you're using the 'sa' login, which is bad security) - that is the user accessing the DB, not the Windows username.
|
![]() |
| Viewing: Dev Articles Community Forums > Databases > Microsoft SQL Server > Windows Authentication |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|