Skip to main content
Glite Dictionary
🔑 A deciding factor 📖 A meaning giver 💻 Database owner
definer

definer

8.5
The user account a database routine uses to decide who can run it
  • noun
  • /dɪˈfaɪnər/
  • Specialized
translation icon : definidor
  • The definer of the stored procedure determines which privileges are used during execution.

Examples

  • You should check the definer setting to ensure the correct permissions are applied.

  • If the definer account is deleted, the database function may stop working.

  • The definer controls access to the database.

  • Can you identify the definers for this function?

  • The definer of the stored procedure determines which privileges are used during execution.

  • If the definer account is deleted, the database function may stop working.

  • You should check the definer setting to ensure the correct permissions are applied.

Surface Forms

definer singular
definers plural

Morphology

definer = define (semi-transparent) = define + er

Morphology is regular (agentive '-er'), but the specialized computing role 'definer' as a database authority is domain-specific and may not be obvious to general learners.

Etymology

Definer comes from define, from the old root finire meaning 'to end' or 'limit', which you can see in final and finish. So in computing a definer is the account that 'sets the limits' or authority for a database routine, which is why it controls permissions.