๐Ÿ’ป Programming/Oracle 11g

[Oracle/SQL] ํŠน์ • ์‚ฌ์šฉ์ž์˜ ๊ถŒํ•œ ์กฐํšŒ

์ผ€์ด์น˜ 2015. 4. 20. 17:13

์‚ฌ์šฉ์ž๊ณ„์ •์ด SAMPLE ์ธ ์‚ฌ์šฉ์ž์˜ ๊ถŒํ•œ์„ ์กฐํšŒํ•˜๋ ค๋ฉด ์•„๋ž˜์™€ ๊ฐ™์ด ํ•˜์‹œ๋ฉด ๋ฉ๋‹ˆ๋‹ค.

select privilege
from dba_sys_privs
where grantee='SAMPLE'
order by 1;