Options

Projection access Grants

Adrian_Oprea_1Adrian_Oprea_1
in General Discussion
 Is there a way that we can implement a grant over a specific projection ? 
Example : 
grant select on projection_test to user_test;
Could this be implemented ? 

Comments

  • Options
    Cagri_CelebiCagri_Celebi

    When you create a table and grant accesses to it (USAGE on schema and SELECT on table), you let the user access that table's data. Projections are related to the data placement on device (disk) and they are on the lower level, so you cannot access it. Please check out the documentation.
    HP Vertica does not associate privileges directly with projections since they are the underlying storage construct. Privileges may only be granted on the logical storage containers: the tables and views.
    https://my.vertica.com/docs/7.0.x/HTML/index.htm#Authoring/AdministratorsGuide/Security/DBUsersAndPr...


Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Format
SpoilerCodeQuote
Heading 2Heading 1
Emoji
:):D:(;):/:o:s:p:'(:|B):#:*<3o:)>:)
Url
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file
Home • General DiscussionComment As ...