Read Only Table?

Moderator: NorbertKrupa

Post Reply
harryrundles
Intermediate
Intermediate
Posts: 96
Joined: Thu Jul 19, 2012 12:33 am

Read Only Table?

Post by harryrundles » Tue Aug 25, 2015 6:41 pm

Hi,

Can I make a table "read only" in Vertica? In Oracle I can alter a table using a "read only" phrase to make a table read only. Does that concept exist in Vertica?

alter table <<table_name>> read only;
Thanks,
Harry

NorbertKrupa
GURU
GURU
Posts: 527
Joined: Tue Oct 22, 2013 9:36 pm
Location: Chicago, IL
Contact:

Re: Read Only Table?

Post by NorbertKrupa » Wed Aug 26, 2015 3:05 pm

The concept does not exist in Vertica. You could create an external table to a CSV which would not permit DML.
Checkout vertica.tips for more Vertica resources.

harryrundles
Intermediate
Intermediate
Posts: 96
Joined: Thu Jul 19, 2012 12:33 am

Re: Read Only Table?

Post by harryrundles » Fri Aug 28, 2015 2:24 pm

Ok, thanks, Norbertk...
Thanks,
Harry

Post Reply

Return to “New to Vertica Database Administration”