Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
rajk
Starting Member
20 Posts |
 Posted - 2003-08-12 : 08:12:24
|
| 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.ThanksRaj |
|
|
Page47
Master Smack Fu Yak Hacker
2878 Posts |
Posted - 2003-08-12 : 08:41:03
|
| You are probably a member of a Windows Group that is associated with a SQL Login.Jay White{0} |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-08-12 : 12:40:00
|
| Duplicate post:[url]http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=28409[/url]Tara |
|
|
|
rajk
Starting Member
20 Posts |
Posted - 2003-08-13 : 00:56:23
|
| Thanks Page47 and tduggan. |
|
|
|
|
|
|
Windows Authentication