Grant Previleges to Objects and Varrays

[KVN Chary]

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?

[Mauro]

HI.

You can grant execute on temp1_array to USER1 and see that the only
granted object is temp1_array with:

select * from user_tab_privs where table_name like 'TEMP1%';

So, with USER1, you can reference temp1_array but not temp1.

Bye.

kv******@yahoo.com (KVN Chary) wrote in message news:<b6*************************@posting.google.c om>...

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?