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 |
SQL_MAZFS
Starting Member
9 Posts |
Posted - 2014-02-10 : 10:39:52
|
Any body tell me plz.. how I set password on a table in sqlserver 2005 that no body open table.HELP ME PLZ.mazfs |
|
TG
Master Smack Fu Yak Hacker
6065 Posts |
Posted - 2014-02-10 : 11:30:47
|
If any "users" are connected as sa or have sa privs or are db owners in the database then you cannot protect the table. You need to set up your security in such a way that users can only see and do what you explicitly grant them permissions for. Sql server tables are not like excel spreadsheets where you can password protect them.Be One with the OptimizerTG |
|
|
|
|
|