[Progress Communities] [Progress OpenEdge ABL] Forum Post: RE: Any proactive schema lock for exclusive access to perform database changes (SQL92 DDL)?

Status
Not open for further replies.
D

dbeavon

Guest
Thanks, its good to know that the port-number-approach is something that others are already doing. If there were a KB to this effect, that would give the approach a bit more weight... IE. maybe it should even be the "authoritative" approach for doing all DDL changes, (for lack of a single-user mode). Unfortunately I haven't found a KB article about this yet so I'm struggling to convince our OpenEdge DBA's of the efficacy and efficiency of this approach. There isn't a lot to go on. There is mainly just a lot of emphatic hand-waving on my part. As a side, messing with OE database ports is not new to us. Our entire "security" model for ABL client/server involves filtering the database ports in HP-UX and restricting access to the ports as much as possible.

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