Grant problem

[holdingbe]

Hi all,
I given the grant previlage to some user.

Foe example

grant select on star.employees to scott..

star and scott are schema name.from the scott i execute like

select * from star.employees i got output but i execute like select * from employees without schema name i got the error like ora-00942 table or view does'nt exisit..urgently i need ....pls help me

[debasisdas]

Even though the user scott has grant previliges on the employees table ,scott is not the user of the table .
scott tries to select from table of another user.
so every time scott has to qualify the object name by the schema name.

[rajanbabu23]

try it...

create or replace view employees as
select * from star.employees ;


select * from employees ;