Synonyms for public or group use

If you support a large group of end users, consider creating and assigning a view that flags certain synonyms to be used by certain groups of users.

About this task

The synonyms table that is used to create the view contains a single row for each synonym that belongs to a user group, and a single row for each public synonym. AUTHID is either null or has a value that uniquely identifies the user group.

Procedure

Add an AUTHID column to the synonyms table if it does not have one.
Use a statement similar to the following one to create the view on the synonyms table.
This statement shows a view created for a group of users that have a common user ID, DEPTD02. All users in the DEPTD02 group can use all public synonyms in the table and any synonyms assigned specifically to the group.
Figure 1. Creating a view that controls group and public use of synonyms
```
CREATE VIEW GROUPVIEW (VERB,OBJECT,SYNONYM_DEFINITION)
  AS SELECT VERB, OBJECT, SYNONYM_DEFINITION
     FROM COMMAND_SYNONYMS
     WHERE AUTHID='DEPTD02' OR AUTHID IS NULL
```