Creating Models › Target Servers for Physical Models › Database Property Editors › Hive Physical Property Editors › Hive Support Summary › Define Hive User IDs

Define Hive User IDs

Use the Hive User Id Editor to define database users and their respective properties in a Hive physical model.

Note: The users that are created here

To define Hive users

1. In the Model Explorer, right-click User Ids and click New.

   An instance of a User ID is created.

2. Right-click the instance and click Properties.

   The Hive User Id Editor opens.

   Note: Click New on the toolbar to create a new user. Use the Enter filter text box to filter a very large list of users to quickly locate the one that you want to define.

   Name

   Displays the user name. You can change the user name in this field.

   Generate

   Generates SQL during forward engineering. Clear the check box if you do not want to generate SQL.

3. Click the Roles tab to select or remove role usage.
4. (Optional) Click the Comment tab and enter any comments that you want to associate with the object.
5. (Optional) Click the UDP tab to work with user-defined properties for the object.
6. (Optional) Click the Notes tab to view and edit user notes.
7. (Optional) Click the Extended Notes tab to view or edit user notes.
8. Click Close.

   The user is defined and the Hive User Id Editor closes.

For more information, refer to Hive documentation.