CartoDB
Turn CDB_TableMetadata to a view
The real metadata should be in a table which is only readable by the superuser while the CDB_TableMetadata should be a view that only allows users to see records for tables they have select privileges on.
Would likely be affected by #21 (tagging tables as configuration tables). Might need to wait for 0.2, to do the change in a migration script.
NOTE: moving the actual data into another table would require updating the DDL triggers to manipulate data in the real table
I've a working version of this rename. The .sql script would create a "shadow" table and copy any pre-existing data there, then turn CDB_TableMetadata into a view. The "from unpackaged" script would copy again the data from "public" to "cartodb" schema.
I've pushed the change in a new "TableMetadataView" branch, as it might be changed in a later release \cc @kartones
NOTE: the change is one-way only, when using the lib/sql (direct) script loading as a way to upgrade/downgrade