Okuzeka
Software Engineering vocabulary · Databases and Persistence

Role

Meaning in software engineering, with examples

/roʊl/nounCommon term

In software engineering, 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 types SQL code into a form or URL so that the database runs it, which can expose or delete data.

This word in other fields

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

More terms: Databases and Persistence

Practise with graded reading

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