Take a good look at the Data View Web Part. I believe this will be your
ticket.

In Frontpage use the data view webpart. But to restrict access
depending on user I think you have to write custom connectable webparts
unless you have the users and their rights also available in your
database then you can select the rights for the current user and provide
them as filter to the data view webpart.