[progress Communities] [progress Openedge Abl] Forum Post: Re: Username Not Displayed In Promon

  • Thread starter Thread starter Betty Hardin
  • Start date Start date
Status
Not open for further replies.
B

Betty Hardin

Guest
This is the solution: ODBC users connect as “sysprogress” without having any _User table user defined for “sysprogress” . This works if sysprogress is the only sql DBA defined in the db – in table _sysdbauth. Step 1: Add 'sysprogress' to the _user table to all progress dbs used by ODBC Step 2: Connect to the db via ODBC Step 3: View users with access to the database select * from sysprogress.sysdbauth Step 4. Revoke permissions from the 'new' dba user (which was added by the dump / load) revoke resource,dba from 'newuser' Step 5. Remove sysprogress from the _user table in all dbs used by ODBC

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