Okuzeka
Databases & SQL vocabulary · Administration and Security

Privilege

Meaning in databases & SQL, with examples

/ˈprɪvəlɪdʒ/nounCommon term

In databases & SQL, privilege means: A permission that allows a database user or role to do a specific action, such as reading a table, inserting rows or creating new objects.

In Turkish: yetki, ayrıcalık

How it is used

Privileges are granted and revoked with GRANT and REVOKE. Good practice follows the principle of least privilege: each user gets only what it needs, and applications never connect as a superuser. 'Insufficient privileges' and 'permission denied' are common error messages.

Example sentences

  1. The app user has no DELETE privilege on the audit tables.

  2. Following the principle of least privilege, the analytics account can only read.

Common collocations

  • grant a privilege
  • revoke a privilege
  • least privilege
  • insufficient privileges
  • admin privileges
  • grantTo give a database user or role permission to do something, using the SQL GRANT statement; REVOKE takes the permission away again.
  • roleA named set of database privileges that can be given to many users at once, such as read_only or app_writer, to make permission management simpler.
  • DBADatabase administrator: the person responsible for installing, securing, backing up, tuning and keeping a company's databases running.
  • SQL injectionAn attack in which someone puts SQL code into an input field so that the application runs it, letting the attacker read, change or delete data.

This word in other fields

The same English word can have a different meaning in another field:

Practise with graded reading

Reading at the right level is the fastest way to make new words stick. Pick free English books by level: