flamerobin icon indicating copy to clipboard operation
flamerobin copied to clipboard

DDL extraction showing duplicated grant values

Open arvanus opened this issue 5 years ago • 0 comments

Example: GRANT DELETE, DELETE, DELETE, DELETE, DELETE, DELETE, DELETE, DELETE, DELETE, DELETE, DELETE, DELETE, DELETE, DELETE, DELETE, DELETE, DELETE, DELETE, INSERT, INSERT, INSERT, INSERT, INSERT, INSERT, INSERT, INSERT, INSERT, INSERT, INSERT, INSERT, INSERT, INSERT, INSERT, INSERT, INSERT, INSERT, REFERENCES, REFERENCES, REFERENCES, REFERENCES, REFERENCES, REFERENCES, REFERENCES, REFERENCES, REFERENCES, REFERENCES, REFERENCES, REFERENCES, REFERENCES, REFERENCES, REFERENCES, REFERENCES, REFERENCES, REFERENCES, SELECT, SELECT, SELECT, SELECT, SELECT, SELECT, SELECT, SELECT, SELECT, SELECT, SELECT, SELECT, SELECT, SELECT, SELECT, SELECT, SELECT, SELECT, UPDATE, UPDATE, UPDATE, UPDATE, UPDATE, UPDATE, UPDATE, UPDATE, UPDATE, UPDATE, UPDATE, UPDATE, UPDATE, UPDATE, UPDATE, UPDATE, UPDATE, UPDATE ON TABLE_NAME TO PROCEDURE SP_NAME WITH GRANT OPTION;

Apparently If de SP has more than 1 grant to another users for some table, it will appear

arvanus avatar Jun 25 '20 01:06 arvanus