Okuzeka
Databases & SQL vocabulary · Administration and Security

Role

Meaning in databases & SQL, with examples

/roʊl/nounCommon term

In databases & SQL, role means: A 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.

In Turkish: rol

How it is used

Instead of granting privileges user by user, DBAs grant them to roles and then assign roles to users. In PostgreSQL users and roles are technically the same thing. Phrases include 'create a role', 'assign a role' and 'role-based access control' (RBAC).

Example sentences

  1. New analysts get the reporting role, which can read but not modify any table.

  2. Create a separate role for the migration tool with DDL privileges.

Common collocations

  • create a role
  • assign a role
  • role-based access control
  • read-only role
  • privilegeA permission that allows a database user or role to do a specific action, such as reading a table, inserting rows or creating new objects.
  • grantTo give a database user or role permission to do something, using the SQL GRANT statement; REVOKE takes the permission away again.
  • 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: