Grant privileges directly to users with the GRANT statement, documented in Teradata Vantage™ - SQL Data Control Language, B035-1149.
- 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.