Good advice. Sounded like this was going to be used on a local network by a couple people sitting in a room together, so didn't want to complicate things with Auth and logins, but yes this is the way to go if you need to control access and permissions.
Anthony On Monday, February 17, 2014 2:33:17 AM UTC-5, Massimo Di Pierro wrote: > > Anthony's example is great. Anyway, I would recommend replacing this: > > def index(): > return dict(grid=SQLFORM.grid(db.person, user_signature=False)) > > with this: > > @auth.requires_login() > def index(): > return dict(grid=SQLFORM.smartgrid(db.person)) > > user_signature=False will expose all data to users of the system without > requiring a registration/password. Apart for security implications, that > will prevent versioning and auditing database changes. > > On Sunday, 16 February 2014 15:24:55 UTC-6, jimbo wrote: >> >> Anthony that is really good, very impressive and just what I want! From >> memory that so far actually seems to be both simpler and better than what >> MS Access would offer. >> >> A lot of people and companies could make good use of web2py as a >> database, Especially small businesses and charities etc. I need to do a bit >> more delving and get myself up to speed hopefully. However those precise >> instructions are a base for progress, thanks to both yourself and Neo for >> your time. >> >> I will leave this open for a few more days in case anybody else has >> something to add. Many thanks. Jimmy. >> >> On Saturday, 15 February 2014 14:35:49 UTC, jimbo wrote: >>> >>> Hi I am thinking of using web2py for a small database instead of MS >>> Access. It is for a charity and would have only several hundred records of >>> employees and a table for clients. It would run on a local network with >>> probably only two computers using it. The usual name, address , tel no. and >>> some certificate and photo. It would avoid licence fees for a start and I >>> think easier to use via a browser >>> >>> I know a little about Access but very basic. Are there any simple >>> examples of where I could start, or some web2py appliance available? >>> >>> If any you can help or have something I can look at I would be very >>> grateful. It's as much a learing thing for myself as I know virtually >>> nothing aobut DB's. >>> >>> >>> Thanks, Jim >>> >> -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/groups/opt_out.
