Physical Modeling › Teradata Physical Property Editors › Authorize Teradata Database Users

Authorize Teradata Database Users

You can use the Authorization editor to make an association between a database user and an OS server user id in a Teradata physical model. This lets an external routine run in a secured mode using the context, permissions, and access control given to the specified OS user.

In Teradata, objects are owned by databases or users. A database and a user are equivalent with the exception that only a user can login to the database. A database or a user can act as a schema.

Note: Passwords will not be stored, but you can use a UDP to generate a password for forward engineering.

To authorize Teradata database users

  1. Click Authorizations on the Database menu.

    The Authorization Editor opens.

  2. Select an authorization and work with the following options:

    Note: Click New <New> icon in property editors on the toolbar to create a new authorization.

    Name

    Specifies the name of the available authorizations.

    Association Type

    Specifies the type of authorization. Select the type from the drop-down. Valid options are: Definer, Definer Default, and Invoker.

    Database

    Specifies the schema of the database to which the table belongs. Select from the drop-down.

    Use Replace Syntax

    Lets you select whether Forward Engineering will use the REPLACE command instead of the CREATE command.

    Generate

    Generates DDL for this object during Forward Engineering.

  3. Complete the following fields on the General tab:
    OS Domain

    Specifies the domain name for the OS user.

    OS User

    Specifies the OS user.

  4. Click the Permissions tab to associate permissions with the authorization. Features on the Permissions tab enable you to create new permissions, work with existing permissions, and open the Permission Editor to define permission options.
  5. (Optional) Click the Comment tab and enter any comments you want associated with the authorization.
  6. (Optional) Click the UDP tab to work with user-defined properties for the authorization.
  7. Click Close.

    The Authorization Editor closes.

More information:

Add Permissions in a Teradata Property Editor

Add a Comment in a Property Editor

Add a UDP in a Physical Property Editor