The programs of a user form his private SQL-PL library. For the programs in the private library, the user can grant the execute privilege to other users. These users can call the programs, but they cannot modify or delete them.
SQL-PL programs can only be called by users who are known to the database system. For users to be able to build their own programs, they must have the RESOURCE or DBA privilege; i.e., they must be able to create private tables in the database.
SQL-PL is a structured programming language with control structures similar to those in Pascal.