Tech Tip: 4D now supports SQL Schemas
PRODUCT: 4D | VERSION: 11.3 | PLATFORM: Mac & Win
Published On: January 14, 2009
As of 4D v11 SQL Release 3, SQL Schemas are now supported as a way of securing external access to your database (i.e. ODBC and SQL connections). Schemas are created and modified through the use of new SQL Commands such as CREATE SCHEMA, ALTER SCHEMA, GRANT, REVOKE, and DROP SCHEMA. Schemas can be applied to tables either through the Structure Editor's Inspector (see image below) or through the use of the ALTER TABLE SQL command. A component for creating, modifying, and applying schemas also exist within the 4DPop Component.
See Also:
Tech Note - Database Schemas and Security
http://kb.4d.com/search/assetid=51814
4D v11 SQL Release 3 (11.3) Addendum
http://www.4d.com/support/documentation.html