Roles in #MySQL Explained! #shorts #database

In this sql tutorial video we’ll explain one of the concepts concerning mysql server – these concepts are also frequently found as sql interview questions and answers. In this sql interview questions video we’ll go through mysql server roles. Roles in mysql server are collections of privileges; we assign a set of privileges to a role, then assign a role to a specific user in our mysql server. That’s how mysql server roles work.

– CREATE ROLE|DROP ROLE creates or removes roles in MySQL Server.
– GRANT|REVOKE SQL statements assign or revoke privileges.
– SET DEFAULT ROLE SQL query specifies a default role.
– SET ROLE SQL query changes mysql server roles in a session (this is a session-wide parameter.)
– CURRENT_ROLE() SQL query displays the active roles.

Privileges can be granted to either SQL databases or SQL database objects (tables, indexes, views etc.) They can also be dynamic or static.

One can also set mandatory roles by adjusting the mandatory_roles parameter.

Do note that MySQL Server does not yet offer support for Roles-Based Access Control (RBAC) – perhaps they will in the future.

We hope that this sql tutorial will help you answer some of the sql interview questions you could be facing in your next sql interview – good luck!

Music:
Kochi by Lucjo https://soundcloud.com/lucjomusic
Creative Commons — Attribution 3.0 Unported — CC BY 3.0
Free Download / Stream: https://bit.ly/3q9SsAM
Music promoted by Audio Library: https://www.youtube.com/watch?v=ckVl-c4z-W8

#shorts #mysql #sql #developer #web #webdevelopment