Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- USE master;
- GO
- CREATE LOGIN blob WITH PASSWORD = 'x', CHECK_POLICY = OFF;
- GO
- CREATE DATABASE floob;
- GO
- USE floob;
- GO
- CREATE USER blob FROM LOGIN blob;
- GO
- GRANT SHOWPLAN TO blob;
- GO
- CREATE TABLE dbo.splunge(plonk INT);
- GO
- GRANT SELECT ON dbo.splunge TO blob;
- GO
- EXECUTE AS USER = 'blob';
- GO
- SET SHOWPLAN_XML ON;
- GO
- -- plan is shown:
- SELECT plonk FROM dbo.splunge;
- GO
- SET SHOWPLAN_XML OFF;
- GO
- -- error:
- EXEC sp_trace_getdata @traceid = 1;
- GO
- -- empty result set:
- SELECT * FROM sys.traces;
- GO
- REVERT;
- GO
- USE master;
- GO
- DROP DATABASE floob;
- DROP LOGIN blob;
Add Comment
Please, Sign In to add comment