Grant Privileges to Directly Users | VantageCloud Lake - Granting Privileges Directly to Users - Teradata VantageCloud Lake

Lake - Configure and Manage Your Environment and Organization

Deployment
VantageCloud
Edition
Lake
Product
Teradata VantageCloud Lake
Release Number
Publication Date
February 2025
Publication ID
B700-4600-007K
ft:locale
en-US
ft:lastEdition
2025-10-24
dita:mapPath
erj1683672627920.ditamap
dita:ditavalPath
pny1626732985837.ditaval
ft:sourceId
dita
dita:id
erj1683672627920
Not all privileges can or must be granted to roles, but must or can be granted directly to users. For example:
  • System-level privileges. These are for administrators only and must not be granted to other users.
  • Object-level privileges that apply to too few users to require creation of a role.
A user automatically has the privilege to grant most privileges on any database object the user owns to any other user or role. This excludes CREATE and DROP privileges, which are not automatic ownership privileges. The CREATE and DROP privileges must be granted directly to a user, and must include the WITH GRANT OPTION clause, before that user can grant these privileges to others.