SQL Server 2022

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

SELECT *
FROM msdb.dbo.sysjobs;

SELECT 1 AS I --DB Fiddle displays the error if it occurs, so pop it in a table
INTO #Test1;
Msg 229 Level 14 State 5 Line 1
The SELECT permission was denied on the object 'sysjobs', database 'msdb', schema 'dbo'.

--This returns a result set
SELECT I
FROM #Test1;


I


1


SELECT Name
FROM dbo.objects;

SELECT 2 AS I --DB Fiddle displays the error if it occurs, so pop it in a table
FROM #Test2;
Msg 208 Level 16 State 1 Line 1
Invalid object name 'dbo.objects'.

--This gives an invalid object error, as the prior batch aborted
SELECT I
FROM #Test2;
Msg 208 Level 16 State 0 Line 2
Invalid object name '#Test2'.