Database Administration (MOSC)

MOSC Banner

grant select on user_xxxx tables to another user

edited Jan 31, 2014 2:58AM in Database Administration (MOSC) 5 commentsAnswered
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





Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center