Grant Previleges to Objects and Varrays

From: KVN Chary <>
Date: 3 Oct 2003 11:39:26 -0700
Message-ID: <>

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

Original text of this message