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 |
|
zahidnabi
Starting Member
1 Post |
 Posted - 2015-03-09 : 03:38:06
|
| i want to store username and passwords of different file servers and make this table accessible only via 'sa' user(so it can be accessible via a stored procedure). Any ideas how I can accomplish this.Zahid |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2015-03-09 : 06:49:56
|
sa account should be disabled for any number of reasons.Create a new role which sole purpose is accessing the username and password table.But then again, the passwords should be hashed with a salt anyway.
Microsoft SQL Server MVP, MCT, MCSE, MCSA, MCP, MCITP, MCTS, MCDBA |
 |
|
|
|
|
|
access table via only 'sa' user