It's unclear if you're asking a modeling question or a security question. For example, are you asking how grant DW users access only to financial data but not HR ?

Maybe add the proxy account to one of the other server roles.

https://docs.microsoft.com/en-us/sql/relational-databases/security/authentication-access/server-level-roles?view=sql-server-2017

For example:

"dbcreator: Members of the dbcreator fixed server role can create, alter, drop, and restore any database."

Rather than dropping the table, I'd reccomend denying select permission, and then wait at least 45 days before dropping it.

As a DBA and developer, I personally don't need an AI to help me write my code. However, I could really use an AI to monitor my servers, maybe even...

Do we really need AI driven application development?

Just like AI driven cars, it's an interesting concept, and I'm sure it's in our future, but at least here an now, there...

Yes, an index recommendation should be treated like a pharmaceutical add: always consult your DBA, and stop using the index when database bloating and slowness of data movement occurs.

null

• This reply was modified 6 years, 5 months ago by Eric M Russell.

I don't know about AI (ie: speech to code) driven application development, but meta-data driven application development certainly is a thing. T-SQL is adept at generating code. The example below...

• This reply was modified 6 years, 5 months ago by Eric M Russell.

"..The longer I’m in this business, the more I think that many people with 5 years working with SQL Server usually don’t have 1 year of experience 5 times. I’m...

Storage Explorer, Data Explorer, Data Studio, Visual Studio, Visual Studio Express, Visual Studio Code, Data Tools:

Which of these are in the process of being deprecated?

If a stored procedure isn't an option, then another safe guard would be to grant the mssql account used by the Contact page to have only insert permission on this...

What was the nature of the SQL injection, and how did you discover it happened?

One advantage a MVP / Blogger would have in owning Books Online is that they would always be officially right.

In my opinion, it's only [unethical] if we never intended...

I was already disoriented by the new website layout and now this! Perhaps this your way of hinting to Microsoft that you'd actually like to take on the job of...