View access related issue

BhuvanaNagulan

Hello Friends,

 

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 .

 

ThankYou,

Bhuvana Nagulan  

K_Krutiy

 

 

owner always have all permissions to objects he owns.

 

owner does not need any grants.

 

I assume u1 owns both objects    s1.t1 and s2.v1

 

 

In this case all you need to do is

 

 

grant select on s2.v1 to u2 ;

Sam37

you also need to grant usage on schema to the user/role

 

grant usage on schema s2 to u2;