Database object permissions
When starting the execution of an SPL program, before accessing the database objects that appear in the program, a permission check operation is performed to ensure that the current user has the appropriate operating privileges on the referenced objects. The GRANT and REVOKE commands are used to grant and revoke permissions on database objects, respectively. If the current user tries to access an unauthorized data object, then the program will generate an exception.
Variable Declaration
SPL is a programming language structured as a code block. The first section that appears in the code block is the declaration section. The declaration section contains the definitions of variables, cursors, and other types of SPL statements that can be included in this block. In this section, the declaration of variables is discussed in more detail.
Top comments (0)