Last post Dec 20, 2018 09:49 AM by PatriceSc
Dec 17, 2018 06:47 PM|rfinley|LINK
This Electronics part management system, written for MS SQL, has worked great for years.
The client CAD tools work great. Hope to avoid changing the factory configuration if I don't have to (adding db_datareader permissions)
I need to expand this canned solution and with a VB script.
What's the wizard-level method that retrieves records from a DB View if the server won't allow SELECT statements?
Dec 18, 2018 09:25 AM|PatriceSc|LINK
Unclear. There isn't a DBA to which you could talk ? You could alos grant access to the account you are using without going through db_datareader. What are you allowed to do ?
It seems your best bet is to talk with those in charge of enforcing those rules on your server so that they can guide about what they allow for you. To read data you'll need an account allowed to do so one way or the other.
Dec 18, 2018 09:26 AM|Brando ZWZ|LINK
Hope to avoid changing the factory configuration if I don't have to (adding db_datareader permissions)
As far as I know, if you want to query the sql database table, you should have the permission to access the table.
That means you need to configure the sql database to run some query.
More details about how to assin permission to sepcial user, I suggest you could refer to below article:
Dec 19, 2018 09:52 PM|rfinley|LINK
The only drawback to off-the-shelf software is this startup doesn't have a DBA. Just a very patient IT guy who keeps busy.
I didn't know about GRANT.
Have to wait for IT to remove DB_DATAREADER from this login to test it.
I am thankful for your help.
For the next person who's googling for an answer....
Dec 20, 2018 09:49 AM|PatriceSc|LINK
Ah the account was already added to db_datareader? If you need read access to all tables this is fine IMO.
It's a bit hard to understand which constraints you have or are given to you. You are not supposed to "touch" anything that is used by this app including adding accounts to a built in SQL Server role ? Or you try to do give the least privilege to this account
(you need read access on some tables but not all, if you need read access to quite a number of table anotheroption could be to create your own role) ?