i'm using sql server 2000 In my application; i'm getting group rights from database and access to a particular web page would be given according to that rights.

i think; it should be implemented in page loadup but have no idea. I've following intentions

1. when a user login the application; it should be directed according to the userGroup he belongs like if he is an admin then he would be directed to Admin home page; similarly; if he is an ordinary user then he would be directed to his particular page.

can you give me a code example for it?