When you say a job, do you mean a SQL Server Agent job or a Task Scheduler job? In the case of the latter you can easily specify the context...

Yes, you are correct. If their individual systems are compromised and they have linked server connections to the production servers, yes, someone could come in through that method. However, that...

If you're getting results back from QA, albeit intermittently, it sounds like you've got the right setup. Out of curiosity, when you try to use the MySQL command line client,...

You know, I didn't noticed the .. before. That does make a difference. In that case it's going to look for first an object owned by the user, then it'll...

Here is the confirmation. This document was updated on 20 December 2005, so recent indeed:

How to impede Windows NT administrators from administering a clustered instance of...

Here's the review for DBGhost:

DBGhost Review

Look for a file procsyst.sql in the Install directory of your SQL Server installation (default of C:\Program Files\Microsoft SQL Server\MSSQL\Install). If you do a search for sp_spaceused, you'll eventually find...

This is true, though I think the MS documentation only recently has been upgraded where it says sysadmin fixed server rights aren't needed for the cluster account.

Hi David,

I'm a little surprised by your posting of issues with Apex SQL. I know a lot of folks on these forums have had a positive experience with Apex SQL,...

Yes, in a nutshell, when an application role is activated, the user/login "becomes" the application role. The login/user identity and any other permissions or rights are essentially lost.

And as...

Another idea...

Take a business case study where someone is trying to build an application requiring a database. Work through the database objects that'll be needed and generate the database access...

The problem is they have different owners, as robinhc is alluding to. If the view and the table have the same owner, access need only be granted to the view....

What folder are you copying it too? By default, if no path is specified, the folder it should be in is whatever the binaries folder is for that particular install...

Is MyODBC installed on the same systems as the SQL Server or just on the machine with MySQL?

You denied access to BUILTIN\Administrators, and that will affect anyone in the local Administrators group. If you have domain admin rights on the domain in question, that group is in...