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 ...
-
30th September 2009, 10:40 AM #1 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 10:53 AM.
-
-
IDG Tech News
SHARE:
Similar Threads
-
By badders in forum Thin Client and Virtual Machines
Replies: 5
Last Post: 29th September 2010, 02:26 PM
-
By button_ripple in forum MIS Systems
Replies: 2
Last Post: 1st May 2009, 08:17 AM
-
By powdarrmonkey in forum Coding
Replies: 2
Last Post: 30th September 2008, 12:38 PM
-
By sLiDeR in forum Windows
Replies: 1
Last Post: 5th September 2008, 05:43 PM
-
By Mr_M_Cox in forum MIS Systems
Replies: 3
Last Post: 16th August 2007, 03: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
-
Forum Rules