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 |
|
sa4720k
Starting Member
3 Posts |
 Posted - 2012-06-14 : 09:54:54
|
| Hello,I'm having a strange issue while setting up my database security. When I add an Active Directory login to SQL Server he/she automatically become a dbo when I login to SQL Server as this user. Therefore, the following statement 'SELECT CURRENT_USER' with always return 'dbo' instead of the 'Domain\username'. If I do the same thing with a local user/group I don't have this problem.I'm pretty new SQL Server 2008 R2 administration, and I don't know why this is happening. I'd appreciate any help.Thanks |
|
|
nigelrivett
Master Smack Fu Yak Hacker
3385 Posts |
Posted - 2012-06-14 : 10:35:08
|
| Probably a windows admin - local admin on the machine or domain admin?==========================================Cursors are useful if you don't know sql.SSIS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
sa4720k
Starting Member
3 Posts |
Posted - 2012-06-14 : 11:06:21
|
| The user is only in the "public" role and nothing else. I've done a lot of search on the Internet, and it seems that this maybe a bug? Apparently, if you login to SQL Server with a domain account then IS_MEMBER will see you only as DBO therefore IS_MEMBER('rolename') will always return 0 if dbo is not in that role. I have yet to find a workaround for this. |
|
|
|
|
|
|
Active Directory User is automatically dbo