S
steve pittman
Guest
The earlier uggestions by Gus and George are very valuable. About (4), let me reinforce Gus’s suggestion of creating sql-only users. This is do-able in the OE 11.* releases. A sql-only user has no effect on ABL usage or ABL behavior. To get read-only user access, this has to be done by doing GRANTs of Select permission to either specific users or to PUBLIC. PUBLIC means any userid, now or future. By default, ordinary sql users do not have any access to tables, so the access they get is determined by the GRANT that you do. We (sql development) recommend that ordinary user NOT be made DBA’s , and that a userid should not be created for the builtin system DBA “sysprogress”. DBA’s can do any sql operation, and that clearly affects security. It is more work to do table GRANTs, but that gives security and is very important. Thanks for asking this important questions. … steve pittman [OE sql software architect]
Continue reading...
Continue reading...