Skip to main content
Version: 2023

Tags

Introduction to tags​

A tag is a freely definable property that can be linked to rows of a table and can be provided with a value. They provide information that is not available in the Software Factory's meta model.

You can use tags administratively or in a meta control procedure (dynamic model) to manipulate your model. For example, to indicate whether a table is deprecated or should not contain mutation columns.

Tags are available for most entities in the Software Factory, for example, tables, tasks, reports, and roles.

Overview of tags for a branch

Some examples where you can add or edit tags:

  • An overview of all tags within a model: menu Models > Model overview > Models > tab Model tags.
  • An overview of all tags within a branch: menu Models > Model overview > Branches > tab Branch tags.
  • Tables: menu Data > Data model > tab Tables > tab Table tags.
  • Columns: menu Data > Data model > tab Tables > tab Columns > tab Column tags.
  • Tasks: menu Processes > Tasks > tab Default > tab Task tags.
  • Reports: menu Processes > Reports > tab Default > tab Report tags.
  • Roles: menu Access control > Roles > tab Form > tab Role.

Limit database authorization with a tag​

By default, a grant .. on .. public line is added after DLL statements such as creating tables or stored procedures.

To suppress this line, you need to add a tag to a model:

Advanced menu > Model management > Models > tab Model tags > tab Model tags

  1. Select the Model for which you want to suppress grant .. on .. public.
  2. In field Tag, add tag NO_GRANT_TO_PUBLIC.
  3. Generate the model's definition to activate the tag.

Now, the grant .. on .. public line will no longer be added to any procedure within the context of your model.

caution

This affects database authorization for functionality and upgrades for the entire model.

no grant to public Tag: NO_GRANT_TO_PUBLIC