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

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