To Create Application Role

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