SQL_DirectPermissions Job
The SQL_DirectPermissions Job provides information on permissions granted to users at the schema, database, and server level.
Analysis Tasks for the SQL_DirectPermissions Job
Navigate to the Databases > SQL > 3.Permissions > SQL_DirectPermissions > Configure node and select Analysis to view the analysis tasks.
warning
Do not modify or deselect the selected analysis task(s). The analysis task(s) are preconfigured for this job.
The default analysis tasks are:
- Determine database permissions – Creates the SA_SQLServer_DirectPermissions_DatabaseDetails table accessible under the job’s Results node
- Determine schema permissions – Creates the SA_SQLServer_DirectPermissions_SchemaDetails table accessible under the job’s Results node
- Determine server permissions – Creates the SA_SQLServer_DirectPermissions_ServerDetails table accessible under the job’s Results node
In addition to the tables and views created by the analysis tasks, the SQL_DirectPermissions Job produces the following pre-configured reports.
| Report | Description | Default Tags | Report Elements |
|---|---|---|---|
| Database Permissions | This report highlights SQL permissions granted at the database level. | None | This report is comprised of three elements:
|
| Schema Permissions | This report lists all SQL permissions granted at the schema level. | None | This report is comprised of three elements:
|
| Server Permissions | This report highlights SQL permissions being granted at the server level. | None | This report is comprised of three elements:
|