Default PUBLIC Privileges | SQL Data Control Language | Teradata Vantage - 17.10 - Default PUBLIC Privileges - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - Advanced SQL Engine Security Administration

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Administration
Security
Publication ID
B035-1100-171K
Language
English (United States)

By default, the system grants several default privileges to PUBLIC on specific Data Dictionary objects, and all valid database users automatically have PUBLIC privileges. You can grant and revoke PUBLIC privileges according to your site security policy, but you should keep a list of the default privileges so you can re-grant them to PUBLIC if necessary.

Until you make changes, you can query the system to view the default PUBLIC privileges:

SELECT DatabaseName, TableName, AccessRight FROM DBC.AllRights WHERE UserName='PUBLIC' ORDER BY 2, 1;

Default PUBLIC Privileges Required by Client Applications

The following privilege… Granted to PUBLIC on… Affects the following tools and utilities…
SELECT DBC.Databases NetBackup™ Teradata Extension
SELECT DBC.DBCInfo Teradata System Emulation Tool (Teradata SET)
SELECT DBC.TDStats Teradata Viewpoint Stats Manager. See Teradata® Unity™ Installation, Configuration, and Upgrade Guide for Customers, B035-2523.
SELECT DBC.Tables NetBackup™ Teradata Extension, Teradata SET
INSERT, SELECT, DELETE, UPDATE SysAdmin.FastLog a FastExport, FastLoad, MultiLoad
EXECUTE SysAdmin.FastLogIns a FastExport, FastLoad, MultiLoad
SELECT SysAdmin.FastLogRestartV a FastExport, FastLoad, MultiLoad
EXECUTE SysAdmin.FastLogUpd a FastExport, FastLoad, MultiLoad
SELECT SysAdmin.FastLogV a FastExport, FastLoad, MultiLoad
a Denotes an internal table containing FastLoad information.