Disable temporary table creation

Dear,
Is there a way to disallow a user to create a temporary table?
Thanks,
PeterYou could set explicit access-denied permissions for that user on tempdb,
but in so doing you would break numerous system stored procedures, ADO
functions, and a large number of applications and tools out there, for that
user.
-Mark
<pgp.coppens@.pandora.be> wrote in message
news:1115628367.375613.173760@.g14g2000cwa.googlegroups.com...
> Dear,
> Is there a way to disallow a user to create a temporary table?
> Thanks,
> Peter
>|||pgp.coppens,
Why would you want to do that? Could you describe your situation further?
Perhaps you should disallow all direct access to SQL Server tables and only
allow access to data through stored procedures and/or views.
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602m.html
"pgp.coppens@.pandora.be" wrote:

> Dear,
> Is there a way to disallow a user to create a temporary table?
> Thanks,
> Peter
>|||Mark Allison schreef:
> pgp.coppens,
> Why would you want to do that? Could you describe your situation
further?
> Perhaps you should disallow all direct access to SQL Server tables
and only[vbcol=seagreen]
> allow access to data through stored procedures and/or views.
> --
> Mark Allison, SQL Server MVP
> http://www.markallison.co.uk
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602m.html
>
>
> "pgp.coppens@.pandora.be" wrote:
>
Actually I am trying to create an apparently very artificial
environment so that I can document the error messages a user might get
when his server does not allow him to create temporary tables and the
application (I am trying to document) attempts it.
But from the looks of the reactions not many SQLServer servers will be
configured in such a way I guess, so it might not be worth the effort.
Thanks for all your reactions.
Peter