Release 10.1A: OpenEdge Data Management:
Database Administration

> ## Both 4GL and SQL tables

> When you create an OpenEdge database using the PROCOPY or PRODB commands, your login ID is used to automatically designate you as DBA, but only if there are no predefined_USER records or DBAs (other than “sysprogress”) in the source database.

> Then, as creator of the new database, you can:

> - Use the Data Dictionary to designate a 4GL DBA user ID and use it to grant access privileges.

> - Log into the database and use the `GRANT` statement to designate additional SQL DBAs, and use the `CREATE USER` and `DROP USER` statements to add and delete user IDs.

Copyright © 2005 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095