November 13, 2015 at 2:13 am
Hi
A bit of a straw poll .. if you wanted to give Power Users (outside of IT teams) access to data .. be it in a reporting database, normal relational database etc ... would you allow them to use SQL Management Studio .. or insist they use other tools
A recent discussion at work went along the lines of SSMS is for DBA's only and all other users should use other tools. Coming from a BI environment this was quite an interesting statement
What are your thoughts
Thanks
Ian
November 13, 2015 at 7:58 am
In our organization, if there are business users who are more interested in data they use some sort of reporting tools like Tableau or SSRS, so for business users this works great because they don't need to know sql to get the data they need. Now in a small company there is very thin line between business user and developer, for those type of roles ssms would be ideal , how ever even if you give them very limited access they could still bring down the entire system by blowing up the tempdb ( has happened many many times at my previous org).
November 16, 2015 at 11:45 am
It depends on the power users and what they were trying to do.
If they were just writing reports, we'd probably give them access to the SSRS adhoc reporting tools. On the other hand, we do actually have power users with access to SSMS because they have their own databases in which they do table creation, data massaging, and other calculation stuff. It's necessary for their area of business.
Caveat: no one power user has access to Production. EVER.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply