Results 1 to 2 of 2

Thread: SQL Server 2005 security settings

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

    SQL Server 2005 security settings

    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:14 PM #2
    rmiao
    rmiao is offline Registered User
    Join Date
    Sep 2002
    Posts
    5,938
    You have to grant 'create table' permission to db user or put user in db_ddladmin db role.
    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