On Tue, 15 Jul 2003 11:56:48 +0800, Adrian
>>I suggest verifing the results of
>>are the same for "DOM\User1" if its is dbo for USER_NAME() I think it is an
>>already known bug. My memory could be wrong.
>Your suspicions are correct - DOM\User1 is logged on as dbo
>(USER_NAME() returns 'dbo', but SYSTEM_USER returns 'DOM\User1')
>Following on this track I tried IS_MEMBER('db_owner'), which returned
>1 (True), even though DOM\User1 is not the db_owner! (sa is the db
>owner, and is aliased to dbo).
>I will try this with an NT account without any permission on the
>database (except for public) and see how that goes.
I have tested with another NT account and it works fine. It seems
that the account DOM\User1 has some special permissions on this
server, and is automatically logged on as dbo. Unfortunately
IS_MEMBER doesn't work correctly with dbo users, and always return 0