반응형
- /**********************************************************************************************
-- Title : [2k5] 사용자 컨텍스트 전환 및 확인
-- Reference : dBRang.com
-- Key word : setuser execute as user
**********************************************************************************************/ - --SQL 2000
setuser 'usr_mapbak'
select suser_sname(), suser_name(), user_name()
setuser
select suser_sname(), suser_name(), user_name()
--SQL 2005
execute as user='usr_mapbak'
select suser_sname(), suser_name(), user_name()
revert
select suser_sname(), suser_name(), user_name()
반응형