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;
Read Only Table?
Moderator: NorbertKrupa
-
- Intermediate
- Posts: 96
- Joined: Thu Jul 19, 2012 12:33 am
Read Only Table?
Thanks,
Harry
Harry
-
- GURU
- Posts: 527
- Joined: Tue Oct 22, 2013 9:36 pm
- Location: Chicago, IL
- Contact:
Re: Read Only Table?
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.
-
- Intermediate
- Posts: 96
- Joined: Thu Jul 19, 2012 12:33 am