This topic describes the built-in packages provided by PolarDB and how to use the built-in packages.
The specific user sys has full permissions on the built-in packages. When you grant permissions on the packages or revoke the permissions granted on the packages, you must specify this user.
GRANT EXECUTE ON PACKAGE SYS.UTL_FILE TO john;For certain packages, non-superusers must be granted the EXECUTE privilege on the packages before the users use any of the functions or stored procedures in the packages.
For most of the built-in packages, the EXECUTE privilege is granted to PUBLIC by default.
For more information about how to run the GRANT command to provide access to a built-in package, see the GRANT command.