+ Post New Thread
Results 1 to 1 of 1
Windows Server 2000/2003 Thread, MS SQL server database permissions and users in Technical; So, I have a database, lets call it 'till' and a piece of software to administer the data in that ...
  1. #1

    localzuk's Avatar
    Join Date
    Dec 2006
    Location
    Minehead
    Posts
    18,381
    Thank Post
    525
    Thanked 2,615 Times in 2,021 Posts
    Blog Entries
    24
    Rep Power
    891

    MS SQL server database permissions and users

    So, I have a database, lets call it 'till' and a piece of software to administer the data in that db. The application uses the logged in users details to connect to the db, and the users with permissions are a member of an active directory group 'till-managers'.

    Can someone describe the process to me of adding permissions on the DB server to allow everyone in that group read and write access to the database I want.

    As it stands, I've added DOMAIN\till-managers as a login, set the default db as till and set user mappings for that database with the roles 'db_datareader' and 'db_datawriter'.

    I should also mention that the app makes use of stored procedures, views and normal tables.

    What am I missing?
    Last edited by localzuk; 30th September 2009 at 11:53 AM.



SHARE:
+ Post New Thread

Similar Threads

  1. vmware SQL database
    By badders in forum Thin Client and Virtual Machines
    Replies: 5
    Last Post: 29th September 2010, 03:26 PM
  2. No access to any database on SQL server
    By button_ripple in forum MIS Systems
    Replies: 2
    Last Post: 1st May 2009, 09:17 AM
  3. Local system permissions on SQL Server 2005
    By powdarrmonkey in forum Coding
    Replies: 2
    Last Post: 30th September 2008, 01:38 PM
  4. Users folder permissions on server
    By sLiDeR in forum Windows
    Replies: 1
    Last Post: 5th September 2008, 06:43 PM
  5. SQL Database Migration-HELP!!
    By Mr_M_Cox in forum MIS Systems
    Replies: 3
    Last Post: 16th August 2007, 04:24 PM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this 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
  •