grant select on user_xxxx tables to another user
hello, I need to grant select on tables (user is DEV1) : user_segments,user_tab_partitions,user_ind_partitions,user_indexes,user_tables, user_objects.... to user DEV2
-- DEV1 is user
[DEV1@host1] grant select on user_free_space to DV1;
Grant succeeded.
but wen i try:
-- user is DEV2
[DEV2@host1 ] select * from sqlreader.user_free_space;
select * from sqlreader.user_free_space
*
ERROR at line 1:
ORA-00942: table or view does not exist
can you help me to do this grant please.
Regards,
Dj
-- DEV1 is user
[DEV1@host1] grant select on user_free_space to DV1;
Grant succeeded.
but wen i try:
-- user is DEV2
[DEV2@host1 ] select * from sqlreader.user_free_space;
select * from sqlreader.user_free_space
*
ERROR at line 1:
ORA-00942: table or view does not exist
can you help me to do this grant please.
Regards,
Dj
0