Hide User Tables

Hi All,
Is there any way to hide user objects? I want to hide few of my tables in the schema. Is there any bit or something in any system table which i can modify to achieve this. I don't want my tables to be seen through Enterprise Manager.

Regards,
Amit

HI amit,

You don't want to show the table or table content?

If you don't want to show the rows/records to other users, please deny the rights from other users.
But the table name will be visible in the list.

I am not aware of any techinque to hide an object from the user database. If anyone knows, please share it.

Thanks
-Johnson

Suggestion: move the tables to a different database, and refer to them as database.owner.table in views and sp's.

Problem is that you can't set relationships across databases, so you'd have to create triggers on both ends to handle data integrity.

I think there is not such facility to hide user tables.
You can only set restrictions.

I agree that if you need this degree of obfuscation, then you are already allowing users too far in. You need a customized interface, other than Enterprise Manager and/or Query Analyzer.

In SQL Server 2005's new tool called Management Studio, go to Tools / Options / Environment / General and choose "Hide objects in Object Explorer." Unlike Enterprise Manager, where this setting takes effect immediately, you will need to restart Management Studio to get rid of the clutter.



VSNREDDY

Be pure to do good.[Vivekananda]

yes...as ysnreddi said there is an option for us to hide objects in sql server 2005..
but i think it's not possible in sql server 2000
we can only set restrictions....

krishna chaitanya.s
project engineer-SQLDBA

Hi Frank,
You mentioned a hack. Could you please elaborate on that? I also heard that there is something possible after manipulating system tables.

Johnson,
I want to hide table names and not the data

Ranjit, VSNREDDY & krishna,
You didn't need to reply in case you don't know it. No point in just increasing the number of posts. You are just taking the thread to different direction.


Amit

<blockquote id="quote"><font size="1" face="Verdana, Arial, Helvetica" id="quote">quote:<hr height="1" noshade id="quote"><i>Originally posted by amitm79</i><br />Ranjit, VSNREDDY & krishna,<br /> You didn't need to reply in case you don't know it. No point in just increasing the number of posts. You are just taking the thread to different direction.<br />Amit<br /><hr height="1" noshade id="quote"></font id="quote"></blockquote id="quote"><br /><br />You Should better mind your language.[}<img src='/community/emoticons/emotion-1.gif' alt='' />]<br />What rubbish have you posted.[<img src='/community/emoticons/emotion-6.gif' alt='' />!]<br />How can you Judge about others how much they know.[}<img src='/community/emoticons/emotion-1.gif' alt='' />]<br />You better judge your knowledge and if you are born with sharp mind then you can keep yourself away from the forum by not asking any question.[<img src='/community/emoticons/emotion-6.gif' alt='' />!]<br />We all are here to help each other.[<img src='/community/emoticons/emotion-1.gif' alt='' />]<br />If the post is useless to you then ignore it but think twice before commenting anything.[<img src='/community/emoticons/emotion-4.gif' alt='' />][<img src='/community/emoticons/emotion-4.gif' alt='' />]

Ranjit, VSNREDDY & krishna,
You didn't need to reply in case you don't know it. No point in just increasing the number of posts. You are just taking the thread to different direction.


Amit

-----------------------------------------------------------------------------------

Hi Amit..

If you know ,share with forum..please dont discrise any bdy..

VSNREDDY

Be pure to do good.[Vivekananda]

Let's keep things civil guys. We're all here to help each other.

MeanOldDBA
derrickleggett@hotmail.com

When life gives you a lemon, fire the DBA.