The macro only works with local passwords, not with federated ones, for example Google Apps auth.
We're actively working on delivering this feature. Administrators will be able to specify a startup parameter to enable/disable the password prompt. The feature will also follow the Confluence's External User Management mechanism to automatically detect presence of SSO/external user management. More to come soon!