Solved

SQL Permissions

Posted on 2014-03-26
1
314 Views
Last Modified: 2014-04-10
Hi,

I have a SQL database.  Another applications needs to access this via a System DSN connection.
At the moment the only thing I have that captures which users need to access this database is a mailing list.
How do I best handle this?  Do I need to add each users into the database?  Should I create a single user ‘SoftwareAccess’ and distribution that same account to the users that need it?

Any suggestions appreciated?
0
Comment
Question by:andyw27
1 Comment
 
LVL 39

Accepted Solution

by:
lcohan earned 500 total points
ID: 39956364
"Another applications needs to access this via a System DSN connection."

That could be indeed a single SQL Login but then your APP must be able to challenge each user for ID(email) and Password and these indeed can stay in that SQL Database into a "UserLogin" table.
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.
Via a live example, show how to shrink a transaction log file down to a reasonable size.

708 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now