Grant on table with Nested Column.
Hi,
I looked for an answer to this issue, but I couldn't find it. So, here it is. I am trying to grant select on a table with nested column to a different user and still the select won't work. Here is an example.
FIRST_USER@TST > create type test_object as object(ref01 varchar2(3));
2 /
Type created.
FIRST_USER@TST > create type test_type is table of test_object;
2 /
Type created.
"afiedt.buf" 3 lines, 100 characters
1 create table table1 (x varchar2(1), y test_type)
2* nested table y store as type1_nt return as value
FIRST_USER@TST > /
Table created.
FIRST_USER@TST > grant select on table1 to SECOND_USER;
Grant succeeded.
SECOND_USER @TST > select * from FIRST_USER.table1;
select * from FIRST_USER.table1
*
ERROR at line 1:
ORA-01031: insufficient privileges
I am sure I am missing something. I may have to give the grant a different way maybe? Please help.
Thank you.