Enterprise Edition Home | Express Edition Home | Previous Page | Next Page   SQL Statements > CREATE PROCEDURE >

Privileges Necessary for Using CREATE PROCEDURE

You must have the Resource privilege on a database to create a user-defined procedure within that database.

In Dynamic Server, before you can create an SPL procedure, you must also have the Usage privilege on the SPL language. For more information, see Usage Privilege in Stored Procedure Language.

By default, the Usage privilege on SPL is granted to PUBLIC. You must also have at least the Resource privilege on a database to create an SPL procedure within that database.

Enterprise Edition Home | Express Edition Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]