We're Moving!

The Vertica Forum is moving to a new OpenText Analytics Database (Vertica) Community.

Join us there to post discussion topics, learn about

product releases, share tips, access the blog, and much more.

Create My New Community Account Now


Projection access Grants — Vertica Forum

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

  • 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 ...