Restrict object creation

To put restraints on what objects are built and how they are built, use SPL routines within the following setting:

• You are the DBA of the database.
• All the other users have the Connect privilege to the database. They do not have the Resource privilege.
• You use the DBA keyword to create an SPL routine (or set of SPL routines).
• Your SPL routine (or set of SPL routines) creates tables, indexes, and views in the way you define them. You might use such a routine to set up a training database environment.

Your SPL routine might include the creation of one or more tables and associated indexes, as the following example shows:

CREATE DBA PROCEDURE all_objects()

CREATE TABLE learn1 (intone SERIAL, inttwo INT NOT NULL,
   charcol CHAR(10) );
CREATE INDEX learn_ix ON learn1 (inttwo);
CREATE TABLE toys (name CHAR(15) NOT NULL UNIQUE,
   description CHAR(30), on_hand INT);
END PROCEDURE;