I would like to share the data in the USER_SEGMENTS table with another schema. If I create a view and grant select on the view, when the other schema queries the view the data is identical to themselves querying the SYS.user_segments table directly.
create view sys_user_segments as select * from sys.user_segments;
grant select on sys_user_segments to A;
My guess is that the SYS.user_segments table is a view based on the current user.
Is there a way to share this data without creating a copy of the table?
Oracle: 10g
Thanks