March 15, 2019 at 8:49 am
I have a SQL 2017 server and are accessed via MS Access 2016 on the workstation.Active Directory integration allows me to use AD security in SQL security. I need ability to access the SQL DB's from a web browser so that I can let users access it remotely (still using AD security to log in of course)
March 15, 2019 at 9:29 am
to do what, data entry? Manage the tables?
-------------------------------------------------------------------------------------------------------------------------------------
Please follow Best Practices For Posting On Forums to receive quicker and higher quality responses
March 15, 2019 at 12:05 pm
To perform both. it was a client request.
March 18, 2019 at 10:03 am
dallas.teche - Friday, March 15, 2019 12:05 PMTo perform both. it was a client request.
Bad idea. In all ways. Users should not be directly managing tables. Ever. People without database expertise are going to mess things up in one heck of a hurry. Also, you'd have to spend as much effort or more, building such a web application. There are no built-in web apps for managing the tables. And for darn good reason. Best you could do "out of the box" is to prepare SSRS reports for the users and give them the links to the reports. Those are served up via the web, and you can control who has access to which report folders using AD.
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)
March 18, 2019 at 11:15 am
sgmunson - Monday, March 18, 2019 10:03 AMdallas.teche - Friday, March 15, 2019 12:05 PMTo perform both. it was a client request.Bad idea. In all ways. Users should not be directly managing tables. Ever. People without database expertise are going to mess things up in one heck of a hurry. Also, you'd have to spend as much effort or more, building such a web application. There are no built-in web apps for managing the tables. And for darn good reason. Best you could do "out of the box" is to prepare SSRS reports for the users and give them the links to the reports. Those are served up via the web, and you can control who has access to which report folders using AD.
+1 million...
What you're trying to do is create an easy to use SQL Injection interface.
March 18, 2019 at 12:34 pm
Jason A. Long - Monday, March 18, 2019 11:15 AM+1 million...
What you're trying to do is create an easy to use SQL Injection interface.
ooh, market it as "SQL IIS"..."SQL Injection Interface System"
-------------------------------------------------------------------------------------------------------------------------------------
Please follow Best Practices For Posting On Forums to receive quicker and higher quality responses
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply