Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!

View access related issue

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  

Comments

  •  

     

    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 ;

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

     

    grant usage on schema s2 to u2;

     

     

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.