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.
- 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.