Hi all - I have a potentially tricky task... I have written some code in my V4.5.3 DNN portal to programatically add a user to a role when an event occurs, the role grants them access to a set of hidden pages on the site and I also need to grant them access to a child portal on the site

So I need to work out the code to...

a) Add a user to a child portal on my site.

b) Add a user into a security role on the child portal on my site.

A quick search has turned up nothing so far so any help would be hugely welcome.

Kevin

Adding the user to the child portal is fairly simple.  The way to add the user to the portal is to add an entry into the UserPortals table.  It is pretty basic, just five columns of data, to complete this.  I wrote a module a bit back that add the user based upon input and behind the scenes this is really all that the module does.  As for adding a user to a role, I imagine it would be a bit more difficult but along the same lines.  I haven't seen anybody acutally do this with a module or code but you would need to find out which tables adding the user into a role affects and then write to code to perform the same actions.  Just looking at the tables in the database I would say that you are going to have to add an entry in UserRoles to handle this.  It looks like this table keeps an entry for the user and the users role based upon the Id found in the Roles table.  Again, I haven't seen anybody mention that they do this but it should be possible. 

Hi Kevin,

I am using DotNetNuke 4.05.03 and trying to add new users through a Windows Application. Will it be possible to send me the Stored procedures.

Thanks