The users access group that is stored in the users table can be stored in a session variable by the Login Behavior.
There is a tutorial for user level authentication in the Archived Documentation section of the security assist support page, it was written for security assist 1, but the concept is still the same in sercurity assist 2.
2) No, neither Dreamweaver or Security Assist will not work with a PostgreSQL database