In SQL Server 2000, it was difficult to allow users to see the SQL Server Agent jobs on your database server without giving the user sysadmin permissions. SQL Server 2005 makes assigning this ...

but developers and database administrators often find it useful to write SQL to speak directly to the database, and others users sometimes find it useful as well to be able to craft their own ...

In the above demo, I included all the tables in my Azure SQL Database (AdventureWorksLT ... the security context of the calling user, so they will only see tables and columns they can access.