Sobes.tech
Senior

Tell me more about database security: users, logins, permissions — what did you do at the user level?

sobes.tech AI

Answer from AI

Database security is built on access control through users, logins, and permissions.

  • Users are accounts assigned access rights.
  • Logins are authentication means linking a user to the system.
  • Permissions are rights to perform operations (SELECT, INSERT, UPDATE, DELETE, etc.) on database objects.

In practice, I created users with the minimum necessary rights (principle of least privilege), configured roles for groups of users to simplify access management. I also used auditing and monitoring to track user actions to detect suspicious activity in a timely manner.