I've been asked to do a very interesting thing. My HR department is having a database-app created for thier use. They DO NOT want SQL Administrators to have any access to this database.
How do I keep S.A. out of the database and still allow them to do admin functionality on the SQL server?
how do I deny DBO access to user tables?
Thanks in advance
View Complete Post