search

mariuz / flamerobin

FlameRobin is a database administration tool for Firebird RDBMS. Our goal is to build a tool that is: lightweight (small footprint, fast execution) cross-platform (Linux, Windows, Mac OS X, FreeBSD) dependent only on other Open Source software
http://flamerobin.org
MIT License
216 stars 67 forks source link

DDL extraction showing duplicated grant values #40

Closed arvanus closed 1 year ago

arvanus commented 4 years ago

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