Create Table Permission for Domain Users Group

From: Rob Taylor (rob@webadviser.info)
Date: 07/04/02 

From: "Rob Taylor" <rob@webadviser.info>
Date: Thu, 4 Jul 2002 11:17:11 +0100

Hi

I have the following SQL Server 2000 issue:

===============

1. SQL logins are via Windows authentication only

2. The majority of users will use the Domain Users NT group to access SQL
resources

3. I have written a stored proc that (amongst other things) creates a temp
table then drops it again before returning a resultset

4. The temp table name is different for each user (concatenation of two sp
input parameters)

5. I have give the Domain Users group execute permissions on the sp

6. I currently get a error when the sp runs confirming insufficient
permissions to create table

===============

Q: How do I give the Domain Users group CREATE/DROP TABLE permissions but
ONLY for the temp table created in the sp?

Any thoughts much appreciated!

regards

Rob

Relevant Pages

  • Create Table Permission for Domain Users Group
    ... If you use the "#" prefix the table is created in tempdb ... The majority of users will use the Domain Users NT ... The temp table name is different for each user ... I have give the Domain Users group execute permissions ...
    (microsoft.public.sqlserver.security)
  • Re: ASP access to SQL Database
    ... taking some first steps with a test DB in SQL and some ASP pages. ... project involving a major DB with lookups from Domain users via ASP on IIS ... them as Logins, and then specify the database rights for the logins. ...
    (microsoft.public.windows.server.sbs)
  • Re: most restrictive or least?
    ... >makes sense as far as deny goes. ... group is a user in SQL ... >2) domain users can SELECT some tables ... >Server) to be just like the above but have UPDATE on one ...
    (microsoft.public.sqlserver.security)
  • Re: ASP access to SQL Database
    ... Ours is showing set to "Windows Only" rather than "SQL ... Is this normal default for SBS? ... project involving a major DB with lookups from Domain users via ASP on IIS ... them as Logins, and then specify the database rights for the logins. ...
    (microsoft.public.windows.server.sbs)
  • Re: ASP access to SQL Database
    ... taking some first steps with a test DB in SQL and some ASP pages. ... If the plan is to make use of domain user accounts, this is fine, but you need to configure IIS to impersonate the domain users *and* to add the domain users to SQL. ... To configure SQL Access for domain accounts, use Enterprise Manager to add them as Logins, and then specify the database rights for the logins. ...
    (microsoft.public.windows.server.sbs)