The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.
Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!
Projection access Grants
Is there a way that we can implement a grant over a specific projection ?
grant select on projection_test to user_test;Could this be implemented ?
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. https://my.vertica.com/docs/7.0.x/HTML/index.htm#Authoring/AdministratorsGuide/Security/DBUsersAndPr...