[Progress Communities] [Progress OpenEdge ABL] Forum Post: RE: Read-only SQL92 connections to an OpenEdge database

  • Thread starter Thread starter Rob Fitzpatrick
  • Start date Start date
Status
Not open for further replies.
R

Rob Fitzpatrick

Guest
First, make sure the user isn't a SQL DBA. ;) Check sysprogress.sysdbauth. Second, check the user's table-level permissions in sysprogress.systabauth. They should only be granted SELECT permission on the tables they need to read. They shouldn't have any other permissions.

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