Suggest an editImprove this articleRefine the answer for “What are access privileges (privileges)?”. Your changes go to moderation before they’re published.Approval requiredContentWhat you’re changing🇺🇸EN🇺🇦UAPreviewTitle (EN)Short answer (EN)**Privileges** are **permissions** that define **what a user can do** in a database: `SELECT` (read), `INSERT` (add), `UPDATE` (change), `DELETE` (remove rows), `CREATE`/`DROP`/`ALTER` (manage objects), or `EXECUTE` (run functions). **Key point:** privileges are granted via `GRANT SELECT, INSERT ON employees TO analyst` and revoked via `REVOKE INSERT ON employees FROM analyst` - privileges are rules that tell the DBMS which actions a specific user is allowed to perform.Shown above the full answer for quick recall.Answer (EN)Image**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 ```sql GRANT SELECT, INSERT ON employees TO analyst; ``` Now the `analyst` user can **read** and **add** data to the `employees` table. Privileges can also be **revoked**: ```sql REVOKE INSERT ON employees FROM analyst; ``` So **privileges are rules** that tell the DBMS which actions a specific user is allowed to perform.For the reviewerNote to the moderator (optional)Visible only to the moderator. Helps review go faster.