How to go about extracting the DDL for user profiles on a database?
In order to do this, you will need the DB Admin module in your license. Check in the Help | Licensing window to verify if you are license for it. If you have the module, please do the following:
1. Look for the Profiles tab in the Schema Browser. If you don't have it, right click on any tabs and select "Configure" select Profiles tab to show.
2. In the Profiles tab, right on a profile and select create script