Question: Can we add custom fields to the four Alpha Anywhere Security tables?


Answer: Absolutely not. Security is important, do not interfere with the structure of the original Alpha Anywhere Security tables.


Using your preferred SQL tool, create only the security table userparms in the database, using the data definition file in your C:\_masters\training folder.

  • Examine the table’s definition. You can use this table to display a “friendly name” to the user when they are working with the application.

You will see an example later in this section