Restrict access to a table (SPL)

SPL routines offer the ability to restrict access to a table. For example, if a database administrator grants insert permissions to a user, that user can use Informix® ESQL/C, DB-Access, or an application program to insert a row. This situation could create a problem if an administrator wants to enforce any business rules.

Using the extra level of security that SPL routines provide, you can enforce business rules. For example, you might have a business rule that a row must be archived before it is deleted. You can write an SPL routine that accomplishes both tasks and prohibits users from directly accessing the table.

Rather than granting insert privileges, an administrator can force users to execute a routine to perform the insert.