1 |
<BR>declare @userid varchar(20)<BR>select @userid = 'guest' -- user명을 입력<BR>select user_id = user_name(uid),<BR> objectname = object_name(id),<BR> 권한=case action <BR> when 193 then 'SELECT' <BR> end<BR>from sysprotects <BR>where uid = user_id(@userid) <BR><BR> |
————————————————————결과user_id objectname 권한guest TABLE1 SELECTguest TABLE2 SELECTguest SP1 … Learn more