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_at_yahoo.com (KVN Chary) wrote in message news:<b6ec1ff3.0310031039.3a3a08d_at_posting.google.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?
Received on Thu Oct 09 2003 - 11:07:13 CEST