16.10 - Granting Privileges to Permanent Database Users - Teradata Database

Teradata Database Security Administration

prodname
Teradata Database
vrm_release
16.10
created_date
June 2017
category
Administration
Security
featnum
B035-1100-161K

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.