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 |
|
zubamark
Starting Member
23 Posts |
 Posted - 2008-05-06 : 13:24:03
|
| Hi,Can I create invisible table in SQL Server 2005?Access(all versions) has this option if you add Usys_TableName. The table will be invisible, but you can get data from itMark |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-05-06 : 13:25:18
|
| Why?? |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-05-06 : 13:27:38
|
| This is not possible with SQL Server. The most you could do is create a table that no one has access to it via permissions, but then they won't be able to retrieve data from it either.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Database maintenance routines:http://weblogs.sqlteam.com/tarad/archive/2004/07/02/1705.aspx |
|
|
|
X002548
Not Just a Number
15586 Posts |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-05-06 : 13:49:15
|
quote:
Originally posted by X002548
Change the font color to be white
 That made my day!Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Database maintenance routines:http://weblogs.sqlteam.com/tarad/archive/2004/07/02/1705.aspx |
|
|
|
mcrowley
Aged Yak Warrior
771 Posts |
Posted - 2008-05-06 : 14:14:58
|
| under SQL Server 2005, if you have no permissions on an object, that object will not be displayed to you in the GUI tools. To make the objects appear in listings, you can grant VIEW DEFINITION on the schema.In fact, the system tables behave differently to someone without the VIEW DEFINITION right. The tables you di not have VIEW DEFINITION rights to are not even displayed. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-05-06 : 22:15:37
|
| You have to deny VIEW DEFINITION permission on the table from user, otherwise user can still see the table. |
|
|
|
|
|
|
How to create invisible table in 2005?