I never thought of doing that but I cannot think of any drawback either. It is clever.
Massimo On Sep 26, 4:23 pm, CJSteel <[email protected]> wrote: > Massimo, Thank you for responding so quickly and at 1:00 am on > Saturday morning no less! > > I have another question at the end of this email that I would > appreciate feedback on. > > Purchased web2py 2nd edition from lulu a couple of weeks ago, > (excellent, thank you for all the hard work!) and will have another > look at chapter 8. > > My goal is to give "less geeky folks", and myself, the ability to use > appadmin and/or another controller file, to assign table permissions > for tables defined in the standard db.py location. > > I moved my test tables back to the normal location in db.py and added > the following to the very end of db.py: > > db.auth_permission.table_name.requires = IS_IN_SET(db.tables) > > This seems to work just fine, now visiting > > http://127.0.0.1:8000/authentication/appadmin/insert/db/auth_permission > > shows a drop down for the values in db.auth_permissions.table_name > that contains the names of the tables I have defined in the normal > db.py location (as well as the table names for auth_user, auth_group, > auth_membership, auth_permissions and auth_event which show up in the > "out of box" web2py setup). > > This will make testing fine grained CRUD authorizations go much more > quickly. I still need to manually change the Name field from "default" > to a CRUD understood permissions Name (ie, read, create, update, > delete, select ) but this is not a big deal. Before I had to use the > shell, which works just fine, but locks other users (and sometime me) > out of the database and perhaps more importantly using the shell I > tend to make a lot of typo's. > > I don't think it will cause any problems for me in a live setup but I > will need to read up some more. > > If anyone can think of any drawbacks to having the line: > > db.auth_permission.table_name.requires = IS_IN_SET(db.tables) > > at the very end of the db.py I would appreciate any feedback. > > Thank You > > Christopher Steel --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "web2py-users" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/web2py?hl=en -~----------~----~----~----~------~----~------~--~---
