Name: Check database and server principal mapping
Platform: Sqlserver
Category: Maintenance
Description: Checks if the database owner (dbo) is maped into any Server Login (server principal).
Long description: The Alert also collects statistics for all database users (in all none system databases) including Server login information. Users with principal_id 2, 3 and 4 will not be checked (guest, INFORMATION_SCHEMA and sys).
Version: 2
Default schedule: 0 * * *
Requires engine install: Yes
Compatibility tag: [CDATA[.[type=‘instance’ & databasetype=‘sqlserver’]/instance[maj_version > ‘2005’ & hasengine=‘YES’ & eng_inst_priv = 0 & (engine_edition = ‘Microsoft SQL Server’ | engine_edition = ‘Azure SQL Managed Instance’)

Feedback

Was this helpful?

Yes No
You indicated this topic was not helpful to you ...
Could you please leave a comment telling us why? Thank you!
Thanks for your feedback.

Post your comment on this topic.

Post Comment