To connect GSP with your custom users, you need to create membership and role provider implementations of your users and roles. This task is not specific to GSP so you should be able to find plenty of help on the internet for how to do it. When you are done, you just update the membership and roles sections in web.config to point to your provider implementations.
Roger Martin
Creator and Lead Developer of Gallery Server Pro