I've turned on auth and attempting to use crud.

when I go to my app http://.../data/create/table_name

I get "insufficient privileges"
NOT Authorized
Access Denied

What am I missing?

db.py is as follows:

from gluon.tools import Auth
from gluon.tools import Crud

db = DAL('sqlite://storage.sqlite')

db.define_table (
    'contacts',
    Field('FirstName'),
    Field('LastName', requires=IS_NOT_EMPTY()),
    Field('Address1'),
    Field('Address2'),
    Field('City'),
    Field('State'),
    Field('Zip'),
    Field('Mobile'),
    Field('Work'),
    Field('Fax'),
    Field('Home'),
    Field('EmailAddr'),
    Field('WebURL'),
    Field('JobTitle'),
    Field('Company'),
    Field('CreateDate', 'datetime', default=request.now, writable=False) )

auth = Auth(db)
auth.define_tables(username=True)

crud = Crud(db)
crud.settings.auth = auth
crud.settings.controller = 'default'
crud.settings.create_next = URL('index')

default.py <controller> includes the following:

def give_create_permission(form):
    group_id = auth.id_group('user_%s' % auth.user.id)
    auth.add_permission(group_id, 'read', db.contacts)
    auth.add_permission(group_id, 'create', db.contacts)
    auth.add_permission(group_id, 'select', db.contacts)
    
crud.settings.auth = auth

def create_contacts():
    form = crud.create(db.contacts, onaccept=give_update_permission)
    return dict(form=crud())

-- 

--- 
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.


Reply via email to