What privilege do you need to create a function?
To create a function in your own schema, you must have the CREATE PROCEDURE system privilege. To create a function in another user’s schema, you must have the CREATE ANY PROCEDURE system privilege. To replace a function in another user’s schema, you must have the ALTER ANY PROCEDURE system privilege.
Is it possible to set default privileges for functions and procedures?
It is not possible to set default privileges for functions and procedures separately.) You can change default privileges only for objects that will be created by yourself or by roles that you are a member of. The privileges can be set globally (i.e., for all objects created in the current database), or just for objects created in specified schemas.
How to set default privileges in SQL Server?
The name of the user or user group to which the specified default privileges are applied. The set of privileges to revoke from the specified users or groups for all new tables, functions, or stored procedures created by the specified user. You can set the same privileges and options with the REVOKE clause that you can with the REVOKE command.
How are default privileges defined in PostgreSQL 9.4?
Default privileges that are specified per-schema are added to whatever the global default privileges are for the particular object type. As explained under GRANT, the default privileges for any object type normally grant all grantable permissions to the object owner, and may grant some privileges to PUBLIC as well.
When do you grant privileges to an object?
The privileges can be set globally (i.e., for all objects created in the current database), or just for objects created in specified schemas. As explained under GRANT, the default privileges for any object type normally grant all grantable permissions to the object owner, and may grant some privileges to PUBLIC as well.