October 1, 2009 at 7:16 am
Silverfox (9/29/2009)
Depends on the company mostly, if you have third party apps, they tend to depend on using sql logins.
SQL Logins. Plural? Thought most TPA's just used sa? "Oh - and the password has to be blank, it's hardcoded that way" ...
October 1, 2009 at 7:20 am
Roy Ernest (10/1/2009)
Then the normal users will not be able to connect to the DB V-LAN with their excel and access.
But we all know the users have got to connect Access (so they can offload data to somewhere where they can rewrite the logic and undermine the database design) and Excel (so they can generate needlessly large grids of columns of figures which simply must be printed off. And manipulate the data with convoluted macros that then require data changes to be posted back).
Or am I just a bit jaded?
No, we have Business Objects, training in Business Objects, in-house specialists supporting BO customers... and still they opt for the cheap and cheerless approach.
October 1, 2009 at 7:25 am
Andrew Gothard-467944 (10/1/2009)
Silverfox (9/29/2009)
Depends on the company mostly, if you have third party apps, they tend to depend on using sql logins.SQL Logins. Plural? Thought most TPA's just used sa? "Oh - and the password has to be blank, it's hardcoded that way" ...
Oh I hear you brother, I hear you....
October 1, 2009 at 7:42 am
Ewan Hampson (10/1/2009)
Roy Ernest (10/1/2009)
Then the normal users will not be able to connect to the DB V-LAN with their excel and access.But we all know the users have got to connect Access (so they can offload data to somewhere where they can rewrite the logic and undermine the database design) and Excel (so they can generate needlessly large grids of columns of figures which simply must be printed off. And manipulate the data with convoluted macros that then require data changes to be posted back).
Or am I just a bit jaded?
No, we have Business Objects, training in Business Objects, in-house specialists supporting BO customers... and still they opt for the cheap and cheerless approach.
I think I am lucky... 🙂 We do not allow any user to access the database directly. Not even the Network Admins. Only the DBAs. But we had to fight every inch to get to this level though. We made lots of enemies, but in the end we prevailed.
😀
-Roy
October 1, 2009 at 8:29 am
Ewan Hampson (10/1/2009)
Roy Ernest (10/1/2009)
Then the normal users will not be able to connect to the DB V-LAN with their excel and access.But we all know the users have got to connect Access (so they can offload data to somewhere where they can rewrite the logic and undermine the database design) and Excel (so they can generate needlessly large grids of columns of figures which simply must be printed off. And manipulate the data with convoluted macros that then require data changes to be posted back).
Or am I just a bit jaded?
No, we have Business Objects, training in Business Objects, in-house specialists supporting BO customers... and still they opt for the cheap and cheerless approach.
But, seriously, how else are they supposed to f**g the figures? Don't you enjoy being dragged in and told "Your report is wrong because the beancounters have a spreadsheet that says ... " and having to spend hours highlighting why theirs are wrong (after having to get out the pliers and bamboo slivers out to drag out of them what they're actually doing)? :w00t:
Viewing 5 posts - 16 through 19 (of 19 total)
You must be logged in to reply to this topic. Login to reply