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]

Re: Grant Previleges to Objects and Varrays

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.

kvnchary@yahoo. com (KVN Chary) wrote in message news:<b6ec1ff3. 0310031039.3a3a 08d@posting.goo gle.com>...

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?