I thought I would do a really simple customization, and that is to automatically create a role (based on username) and assign this role to the user when they are created. My first thought was to use one of the sproc's that fire on user add, and add some code there to add them to the role. But my problem is, I can't get the roles to take by directly adding them to the database. I've added it to the DNN_Roles, DNN_UserRoles, aspnet_Roles and aspnet_usersInRoles. After doing this, I can see the correct assignments in the DNN admin, but when I assign module access to their role, it doesn't work.

So, two questions:

1. With this approach, any idea why it's not working?

2. Should I try a different approach, if so, can you give me a little direction to point me the right way?

Thanks!

I hear what your saying, and you are right. However, I still went ahead and brute forced a way to do it in the database. How I did it was to modify the aspnet_Users_CreateUser and AddUser procedures. I added code to auto assign a role in both places and that seemed to do the trick. This produced the behavior I wanted without messing with the code.

Thanks for the reply.

note, that user and roles are cached.

---

Cheers from Germany,
Sebastian Leupold

   

Speed up your DNN Websites with TurboDNN