KNOWLEDGE BASE
Log In    |    Knowledge Base    |    4D Home
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:
Commented by Timothy Penner on February 14, 2013 at 2:07 PM
This mechanism is based on 4D passwords. In order for the SQL server access control to come into effect, the 4D password system must be activated (a password must be assigned to the Designer).
Commented by Jesse Pina on March 30, 2009 at 8:32 AM
More information and examples regarding schemas can be found in the following 2 resources:

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