My Oracle Support Banner

What Methods Can Allow Different Developers to Access and Compare Schema Information (Doc ID 2672132.1)

Last updated on MAY 19, 2020

Applies to:

MySQL Server - Version 8.0 and later
Information in this document applies to any platform.

Goal

Requirements are that developers want to do schema comparison, and request a method to give the developer some privileges so he can do schema comparison without giving select “*.*” because that will allow developer to see password hash string.

The user want to compare and list of routines, functions and triggers.
 

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution
 1. MySQL Workbench Schema Comparison
 2. Set Privileges
 3. Dynamic Privileges
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.