By default, the system grants 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 keep a list of default privileges to regrant 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
| Privilege | Where Granted to PUBLIC | Affected Tools and Utilities |
|---|---|---|
| SELECT | DBC.Databases | NetBackup™ Teradata Extension |
| SELECT | DBC.Tables | NetBackup™ Teradata Extension |
| 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. |