To Create Application Role
security-audit #security-audit
create application role applicationrolename with password = '[password]',
default_schema = schemaname;
go create application role applicationrolename with password = '[password]',
default_schema = schemaname;
go