Default PUBLIC Privileges | SQL Data Control Language | Teradata Vantage - 17.05 - Default PUBLIC Privileges - Teradata Database

Teradata Vantage™ - SQL Data Control Language

prodname
Advanced SQL Engine
Teradata Database
vrm_release
17.00
17.05
created_date
June 2020
category
Programming Reference
featnum
B035-1149-170K

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.