![]() ![]() That doesn’t make any sense at all, I know. To better understand what roles do provide, let’s not use them. Assigning privileges to users is done individually. Users and Privileges in Previous Versions The user names and passwords demonstrated are purely arbitrary and weak. ![]() The examples included in this post are in a personal ‘single-user’ development and learning workstation/environment so be sure and implement those best practices that benefit you for your particular needs or requirements. Here is how the online MySQL documentation defines a role: “A MySQL role is a named collection of privileges”.ĭoesn’t that definition alone seem helpful? However, where I only summarized them there, this current post looks to go deeper and focus solely on roles. You can surely visit, MySQL in 2018: What’s in 8.0 and Other Observations, I wrote for the Severalnines blog here where I mention roles for a high-level overview. Yet, version 8 implements an exceptional, and powerful, SQL standard feature - Roles - which alleviates one of the more redundant areas of the entire process: assigning privileges to a user. In older versions of MySQL, a multiple-user environment is established in a somewhat monotonous and repetitive manner. You can imagine (I know I do) just how difficult a task managing multiple users or groups of users within a database ecosystem is. Buyers of a service need to see their order and payment history….DBA’s need ‘root’ or similar type privileges to run the show….Developers require a slew of permissions and privileges to carry out their work….Analyst need ‘ read access‘, to garner information and insight via querying tables….However, some tables and data should be strictly off-limits (E.g., system tables). While each user does need to access the database at some level, those permissions are not all created equal.įor instance, clients and customers need access to their ‘related user account’ data, but even that should be monitored with some level of control. Database developers, administrators, analyst, etc… - Those maintaining, working with or monitoring the database infrastructure.Application, service, or program users - basically customers or clients using a service.In terms of database systems, I generally think of them in two distinct groups: Database Security is important to any MySQL setup. ![]()
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |