Grant Previleges to Objects and Varrays

create TYPE temp1 AS OBJECT (

    col1 VARCHAR2(20),
    col2 VARCHAR2(20)
)
/

create TYPE temp1_array
AS VARRAY (6) OF temp1
/

Instead of giving execute privilege on Object, I would like to grant the execute privilege only on temp1_array to USER1. Does it grant indirectly execute privilege on Temp1 object or do I have to grant execute privilege to temp1 object explicitly? Received on Fri Oct 03 2003 - 20:39:26 CEST