Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
usafelix
Posting Yak Master
165 Posts |
 Posted - 2015-02-02 : 23:36:01
|
| Anyone can help ?I am distributing rudimentary analysis tools (excel pivot tables) to our functional managers (so we need to keep it simple, distributing passwords is not such a good idea).How I can when i use of data connector from excel connected to sql table and hide password in excel ?Because user every open the excel , they must input the admin password is high risk. |
|
|
gbritton
Master Smack Fu Yak Hacker
2780 Posts |
Posted - 2015-02-03 : 07:06:09
|
| the admin password? Are you kidding me? Why not create a sequel user with very limited permissions that can be used to access the data for those pivots? |
 |
|
|
sz1
Aged Yak Warrior
555 Posts |
Posted - 2015-02-03 : 07:25:54
|
| Agree with gbritton, only allow selects on the tables required. Alternatively, create a Windows AD group containing the users with required access, again setting select permissions on the group level for that AD account.We are the creators of our own reality! |
|
|
|
|
|
|
data connector,hide the password using excel,sql