GRANT ON [PROCEDURE] not emitted for procedures not in a package

darold / ora2pg

Ora2Pg is a free tool used to migrate an Oracle database to a PostgreSQL compatible schema. It connects your Oracle database, scan it automatically and extracts its structure or data, it then generates SQL scripts that you can load into PostgreSQL.

http://www.ora2pg.com/

GNU General Public License v3.0

1.02k stars 343 forks source link

GRANT ON [PROCEDURE] not emitted for procedures not in a package #1590

Closed smileatom closed 1 year ago

smileatom commented 1 year ago

Generator is generating

GRANT ALL ON schema.procedure instead of GRANT ALL ON PROCEDURE Same for revoke and grant execute the word PROCEDURE is missing.

darold commented 1 year ago

Commit d68f45a fix this issue.