Tech Note: Database Schemas and Security
PRODUCT: 4D | VERSION: 11.3 | PLATFORM: Mac & Win
Published On: December 10, 2008
4D v11 SQL Release 3 introduces many improvements and features to the 4D v11 SQL line of products. One particularly useful feature is the support of schemas in 4D's integrated SQL engine. The implementation of this feature has resulted in modifications to the interface and the introduction of new SQL commands. This technical note describes the changes to the interface as well as the new SQL commands. A sample database component is included.
Download Complete Tech Note and Example: Windows | Mac
See Also:
Commented by Timothy Penner on February 14, 2013 at 2:08 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 Thomas Fitch on February 13, 2009 at 4:31 PM
There is similar functionality in the 4D Pop component library in the 4DPop sqlSchemas database. It's also open source so it is a good place to look for more ideas on the implementation of schemas.