Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> plsql
Following SQL produces these results.
select table_name,grantee,PRIVILEGE
from USER_tab_privs a where a.table_name = 'BEER_CLIENT' order by table_name TABLE_NAME GRANTEE PRIVILEGE
------------------------------ ------------------------------ ------------------
----------------------
BEER_CLIENT IWS_WEB_DEV INSERT BEER_CLIENT IWS_WEB_DEV SELECT BEER_CLIENT IWS_WEB_DEV UPDATE BEER_CLIENT IWS_WEB_DEV DELETE
I would like SQL which produces one row as follows,
BEER_CLIENT IWS_WEB_DEV INSERT SELECT UPDATE DELETE Oracle 8.1.7 thanks Received on Tue Jun 18 2002 - 14:02:13 CDT