16.10 - Granting Privileges to Permanent Database Users - Teradata Database

Teradata Database Security Administration

Teradata Database
Release Number
Release Date
June 2017
Content Type
Publication ID
English (United States)

You can grant privileges directly to users with the GRANT statement, for example:

GRANT [privilege ... (, privilege)]
ON [database_name|object_name]
TO user_name ...[, user_name][WITH GRANT OPTION]

You must grant some privileges directly to users:

  • For privileges that you cannot grant to a role, see Limitations on Using Roles.
  • For a few users with truly unique needs, it may be more efficient to grant required privileges directly to the individual users.

Where possible, avoid granting privileges directly to users. Instead, grant privileges to roles and then grant role membership to users with similar database access needs. See Using Roles to Manage Privileges.