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
 General SQL Server Forums
 New to SQL Server Programming
 Hidden Tables

Author  Topic 

Amber_Deslaurier
Starting Member

40 Posts

Posted - 2010-06-21 : 19:38:37
Hi,

Is there a way to CREATE a hidden table which only I can see in my database?

(TERADATA AND SQL SERVER)

Thanks!

Amber

Devart
Posting Yak Master

102 Posts

Posted - 2010-06-22 : 07:47:33
Hello,

If my memory is not a fault, MS SQL Server has no such concept as HIDDEN TABLE. Limiting the access to specified tables may probably solve your problem. To do this, directly prohibit the usage of SELECT, VIEW DEFINITION and other operations.

Best regards,

Devart,
Tools for SQL Server
http://www.devart.com/dbforge/sql
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2010-06-22 : 10:47:44
you can deny accessof table to others if thats what you want

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Go to Top of Page
   

- Advertisement -