?
Solved

SQL Permissions

Posted on 2014-03-26
1
Medium Priority
?
334 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 40

Accepted Solution

by:
lcohan earned 2000 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

What Is Blockchain Technology?

Blockchain is a technology that underpins the success of Bitcoin and other digital currencies, but it has uses far beyond finance. Learn how blockchain works and why it is proving disruptive to other areas of IT.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Lotus Notes has been used since a very long time as an e-mail client and is very popular because of it's unmatched security. In this article we are going to learn about  RRV Bucket corruption and understand various methods to Fix "RRV Bucket Corrupt…
In this blog post, we’ll look at how using thread_statistics can cause high memory usage.
Via a live example, show how to shrink a transaction log file down to a reasonable size.
This is a high-level webinar that covers the history of enterprise open source database use. It addresses both the advantages companies see in using open source database technologies, as well as the fears and reservations they might have. In this…
Suggested Courses

762 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