Check current database user and login user

execute as login = 'TFS4DBA' -------- server login
execute as user='afm' --------- database user

select current_user,SESSION_USER, USER ,system_user,SUSER_SNAME(),SUSER_SID()