andyw27
asked on
SQL Permissions
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?
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?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.