Hi there,

It would probably be quite easy to write an automated sql script to remove any expired roles from the userroles table. You could just set it up using sql agent to run each night at midnight.

Here is the sql to select the users from a specific portal who have an expired role. You could easily modify this to delete the records.

select * from userroles ur inner join userportals up on ur.userid = up.userid
where ur.expirydate is not null and ur.expirydate > getDate()
and up.portalid = 0

I must admit I was a bit shocked when I saw this post.

So when a role expires, it doesn't actually remove that role from the user? yikes, that's going to cause me a huge mess :(

I tried to use the above SQL script, but just got an error.

Any help appreciated.