Movatterモバイル変換

TheCREATE ROUTINE privilege is needed to create stored routines.

TheALTER ROUTINE privilege is needed to alter or drop stored routines. This privilege is granted automatically to the creator of a routine if necessary, and dropped from the creator when the routine is dropped.

TheEXECUTE privilege is required to execute stored routines. However, this privilege is granted automatically to the creator of a routine if necessary (and dropped from the creator when the routine is dropped). Also, the defaultSQL SECURITY characteristic for a routine isDEFINER, which enables users who have access to the database with which the routine is associated to execute the routine.

If theautomatic_sp_privileges system variable is 0, theEXECUTE andALTER ROUTINE privileges are not automatically granted to and dropped from the routine creator.

The creator of a routine is the account used to execute theCREATE statement for it. This might not be the same as the account named as theDEFINER in the routine definition.