Re: Best approach for Graphical table admin

Evan,

If your talking about linked tables with access I guess you have DB2
connect.

Access with a linked table would be the easiest thing to code. However,
your going to need to store the name and password for the ODBC link. For
security I would write a small web app in PHP, served over SSL.

Justin

On Thu, May 28, 2015 at 8:24 PM, Evan Harris <auctionitis@xxxxxxxxx> wrote:

Hi Jon

the thing that made me think of this just happened to be a validation list
- but that is handy to know.

I think I would like to have some general kind of Grid style interface
where I could just connect to a table for ad-hoc maintenance.

If I was gong to go green screen I would probably just settle for DFU as I
don't believe what I want to achieve needs to be much smarter than that -
just a general approach interface into a table.

On Fri, May 29, 2015 at 11:35 AM, Jon Paris <jon.paris@xxxxxxxxxxxxxx>
wrote:

Giovanni has utilities which include Validation List maintenance. Comes
with full source code so you could use it as a foundation if you needed
more that the standard offering.

http://www.easy400.net/webact/start

I think you have to be a registered user to get to that section of the
site.


Jon Paris

www.partner400.com
www.SystemiDeveloper.com

On May 28, 2015, at 7:26 PM, Evan Harris <auctionitis@xxxxxxxxx> wrote:

Hi all

OK, "Best" is probably subjective, but a scenario that came up for me

this

morning had me wondering what the possible approaches to solve an
administration challenge were.

Situation: I have inherited an application that uses authorisation

lists

to

determine whether users are permitted to access certain menu items. I

would

like to make this as "Self service" a function as possible.

My thinking was that rather than give people command line access on a

green

screen I could create a table and based on adds and deletes to that

table

use a trigger to either add or remove users to the required

authorisation

list.

That set me to thinking: what would be the best way to allow people to
administer a table on the i.

I could for instance link a spreadsheet, or an access database or a SQL
Server database and use their in-built GUI tools.

Some of the tooling in Ops Nav would work but then that opens up a

whole

other can of things to lock down.

Using something like Squirrel to access the table is not out of the
question, but I have not thought through how I would limit the access.
Maybe I could create a library and let people administer various table

sin

there.

What other ways could I do this, especially if access via a web browser

was

the preferred approach.

I don't want to build a CGI program for every use-case, I would much

prefer

to have a general approach where I could have something like a grid
presented to people to do simple admin on a table.

I am curious what options others have come up with and used.


--

Regards
Evan Harris
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing

list

To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing

list

To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.

--

Regards
Evan Harris
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.