Re: Best approach for Graphical table admin

[Jon Paris <jon.paris@xxxxxxxxxxxxxx>]

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.