Hi Tom,

  Just thought about it. Your solution works perfectly when we know in advance there are going to be only 4 different privileges - insert, select, update, delete. Here is an alternate solution which would work for any number of privileges that might change dynamically. This solution is in fact inspired by one of yours.

package tmp as
type rc is ref cursor;
procedure p (p_curs in out rc);
end tmp;
/

PACKAGE BODY TMP as
procedure p(p_curs in out rc)
IS
CURSOR curs IS SELECT DISTINCT privilege FROM user_tab_privs WHERE table_name = 'TEMP';
varcur curs%ROWTYPE;
l_stmt VARCHAR2(1000) := 'select grantee, table_name ';
BEGIN
OPEN curs;
LOOP
    FETCH curs INTO varcur;
    EXIT WHEN curs%NOTFOUND;
        l_stmt:=l_stmt||',max(decode(privilege,'''||varcur.privilege||''',''Y'',''N'')) "'||varcur.privilege||'_PRIV"';
END LOOP;
CLOSE curs;
l_stmt:=l_stmt||' from user_tab_privs where table_name = ''TEMP'' group by grantee, table_name';
OPEN p_curs FOR l_stmt;
END;
end tmp;
/

SQL> variable x refcursor;
SQL> exec tmp.p(:x);

PL/SQL procedure successfully completed.

SQL> print :x

and this gives the desired output.