[Progress Communities] [Progress OpenEdge ABL] Forum Post: RE: Database is allowing operations even for non-existing users

  • Thread starter Thread starter ducity
  • Start date Start date
Status
Not open for further replies.
D

ducity

Guest
" sqlexp -db dbname -port XXX -user username-who-created-db-or-sysprogress" .Ummm, once you have any sql user defined (including sysprogress), you must include the Password in the connection request. so, " sqlexp -db dbname -port XXX -user sysprogress" fails. Next: Progress allows you flexibility to configure DB's in development environments and then 'up' the game through various non-prod and production environments. Don't want SQL user for a Database. 1. Only have shared memory connections or 2. Exclude SQL connections by defining ABL only Brokers. (-ServerType 4GL), Want to manage SQL Connection for a Database. Define your sql-users, GRANT them the right access,Define a specific broker for SQL Connections (-ServerType) Added benefit of splitting the Brokers is you can tune both for their respective uses, including the number of connections for each type.

Continue reading...
 
Status
Not open for further replies.
Back
Top