Re: How to get create temp table permission for a user
From: Hari Prasad (hari_prasad_k_at_hotmail.com)
Date: 08/29/04
- Next message: Imulet: "security templates"
- Previous message: Hari Prasad: "Re: Execute permission denied"
- In reply to: Steven Xu: "How to get create temp table permission for a user"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Sun, 29 Aug 2004 14:50:58 +0530
Hi,
Every user has permissions to create temporary tables. These temp tables are
created in the tempdb database
and will get cleared when the session expires/closes.
Thanks
Hari
MCDBA
"Steven Xu" <stevenxiu@yahoo.com> wrote in message
news:#RQhbTajEHA.3320@TK2MSFTNGP11.phx.gbl...
> Hi All,
>
> I add a user webA to database DBA.
> webA will exec a SP in DBA. webA need to create a temporary table #tableA
in
> this SP.
> How can i give webA create temporary table permission.
>
> Thanks for your time,
>
> Steve
>
>
- Next message: Imulet: "security templates"
- Previous message: Hari Prasad: "Re: Execute permission denied"
- In reply to: Steven Xu: "How to get create temp table permission for a user"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
