Teradata Permissions

Because functions are associated with a database, the functions inherit the access rights of that database. It could be useful to create a separate shared database for the functions so that access rights can be customized as needed. In addition, you must have the following permissions to publish the functions in Teradata:
  • CREATE FUNCTION
  • DROP FUNCTION
  • EXECUTE FUNCTION
  • ALTER FUNCTION
Without these permissions, the publishing of the SAS_PUT( ) function and formats fails. To obtain these permissions, contact your database administrator.
For more information about specific permissions, see the SAS In-Database Products: Administrator's Guide.