Grant all privileges
- Last Updated: February 11, 2026
- 1 minute read
- OpenEdge
- Version 13.0
- Documentation
You can use a SQL script file to grant ALL privileges on all the connected
OpenEdge database tables to PUBLIC. The following procedure allows you to generate an
SQL script file to grant ALL privileges on all the database tables for a specific user:
- Connect to the OpenEdge database and run the ABL code to generate the SQL script.
- Execute the SQL script to grant ALL privileges on all the
connected database tables to PUBLIC. Note: The resulting SQL script files may be executed using any JDBC client like the OpenEdge SQL Explorer Tool.
Generate SQL script using ABL client
To generate SQL script syntax to run using a JDBC or ODBC client, run the
following command:
OUTPUT TO VALUE("GrantAll.sql").
FOR EACH _File WHERE _Tbl-Type = "T":
PUT UNFORMATTED "GRANT ALL ON PUB." + QUOTER(_File-Name) + " TO PUBLIC;" SKIP.
END.
PUT UNFORMATTED "COMMIT WORK;" SKIP.
OUTPUT CLOSE.
This will generate a GrantAll.sql file which can be passed to the
SQL Explorer tool.