USAGE Enables calling a stored procedure. ALL [ PRIVILEGES ] Grants all privileges, except OWNERSHIP, on the stored procedure. OWNERSHIP Grants full control over the stored procedure; required to alter the stored procedure. Only a single role can hold this privilege on a specific object at a time. Note that in a managed access schema, only the schema owner (i.e. the role with the OWNERSHIP privilege on the schema) or a role with the MANAGE GRANTS privilege can grant or revoke privileges on objects in the schema, including future grants.

Privileges on Stored Procedures Similar to other database objects (tables, views, UDFs, etc.), stored procedures are owned by a role and have one or more privileges that can be granted to other roles. Currently, the following privileges apply to stored procedures: USAGE OWNERSHIP For a role to use a stored procedure, the role must either be the owner or have been granted USAGE privilege on the stored procedure.