Common Workflows

Identity and access tasks teams run weekly.

On-call: unlock / disable a login

1. Connect to the instance; open the Logins tab.
2. Find the login; unlock or disable/enable as requested.
3. Confirm password policy flags if the account keeps locking.
4. Export a before/after note for the ticket if required.

Grant access from a template

1. Identify the database user / role membership needed.
2. Apply the access template or assign roles on Users / Roles / Permissions tabs.
3. Re-check risk scoring for elevated grants (especially sysadmin / db_owner).

Monthly drift & compliance

1. Run Compliance checks and Drift Detection against your baseline.
2. Investigate new high-risk principals; remediate or document exceptions.
3. Export reports for auditors.