What are access privileges (privileges)?

Privileges are permissions that define what a user can do in a database.

They're how an administrator manages security and separates access.

#Examples of the main privileges

• SELECT, read data from a table;
• INSERT, add new rows;
• UPDATE, change existing data;
• DELETE, remove rows;
• CREATE, create tables, views, functions, and so on;
• DROP, remove objects;
• ALTER, change an object's structure;
• EXECUTE, run functions or procedures.

#Example

Now the analyst user can read and add data to the employees table.

Privileges can also be revoked:

So privileges are rules that tell the DBMS which actions a specific user is allowed to perform.