View access related issue
We (owner- u1)have base table(t1) in one schema (s1) , view(v1) is placed in another schema(s2) . I want the specific type of user(u2) access only the views not the base table . so I have done below :
grant select on s1.t1 to u1 with grant option ;
then grant select on s2.v1 to u2 ;
will this work ?
I am worried about different schema .