Skip to main content
Version: 2022

Tags

Introduction to tags

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

A tag is a freely definable property that can be linked to rows of a table and can be provided with a value. For example, whether a table is deprecated or contains no mutation columns. Tags can be used to provide information for control procedures that are not available in the Software Factory's meta model.

Some examples where you can add or edit tags:

  • An overview of all tags within a project: menu Advanced > Project management > Projects > tab Project tags.
  • An overview of all tags within a project version: menu Projects > Full model > tab 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.

Overview of tags for a project version

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 project:

Advanced menu > Project management > Projects > tab Project tags > tab Project tags

  1. Select the Project for which you want to suppress grant .. on .. public.
  2. In field Tag, add tag NO_GRANT_TO_PUBLIC.
  3. Generate the project'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 project.

warning

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

no grant to public Tag: NO_GRANT_TO_PUBLIC

Was this page helpful?