Results 1 to 2 of 2

Thread: SQL SERVER 2005 security

  1. 08-28-2008, 10:12 AM #1
    neil-j
    neil-j is offline Registered User
    Join Date
    May 2008
    Posts
    6

    SQL SERVER 2005 security

    I don't have much experience with authentication.

    I want to use windows auth to SQL SERVER 2005 database, so that the user can create temporary tables that are created and deleted by a client application process.

    I don't want to grant them server wide roles, but I am using the User Mapping option to give them ALL roles on the actual database that the app is accessing.

    My client app is still throwing up an error regarding not being allowed to create tables.

    Do I have to alloacte server roles?

    Any suggestions of best practice?
    Reply With Quote Reply With Quote
  2. 08-31-2008, 10:19 PM #2
    rmiao
    rmiao is offline Registered User
    Join Date
    Sep 2002
    Posts
    5,938
    Don't cross post, and it's not db design issue at all.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules