CDB_UserTables

List all the tables in your account. Requires admin privileges

Using the function

SELECT CDB_UserTables(perms)
--- Returns a row for each table having given permission with the table name

REF: https://github.com/CartoDB/cartodb/blob/v2.5.2/lib/sql/scripts-available/CDB_UserTables.sql#L1-L7