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 web2py@googlegroups.com
To unsubscribe from this group, send email to
web2py+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/web2py?hl=en
-~----------~----~----~----~------~----~------~--~---
