question

tiwaryrohit143 avatar image
tiwaryrohit143 asked

How to Create an alert for databases where Any object (Tables, Views and SP) should not be referenced

I want to Create an alert for Sandbox(Database) and DataRepository(Database) where Any object (Tables, Views and SP) should not be referenced. Can anyone help me with this ?

t-sqlsql-serversql-server-2012alert
1 comment
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

WRBI avatar image WRBI commented ·

I might be over simplifying this.

If those objects shouldn't be used why don't you revoke permissions to anyone that shouldn't be using them. Surely, creating an alert allows them to use those objects/get at data until you have time to resolve it - imagine being on holiday on for two weeks and your team members don't pick up the alert!

0 Likes 0 ·

0 Answers

·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.