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 2008 Forums
 Transact-SQL (2008)
 Hide Objects

Author  Topic 

Rashednadeem
Starting Member

5 Posts

Posted - 2011-05-01 : 04:59:37
how do we protect all tables, stored procedures and functions from viewing without password?
I saw a database that was protected and the owner opens the database with key but i forgot the kewords he typed there

Rashed

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2011-05-01 : 07:02:22
Nope. If someone is sysadmin they have complete control and nothing can be denied to them.

--
Gail Shaw
SQL Server MVP
Go to Top of Page
   

- Advertisement -