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.

 All Forums
 SQL Server 2005 Forums
 Other SQL Server Topics (2005)
 Password Protection Issue

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 Optimizer
TG
Go to Top of Page
   

- Advertisement -