SQL Server Performance

Hide User Tables

Discussion in 'General Developer Questions' started by amitm79, Nov 11, 2005.

  1. amitm79 New Member

    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
  2. johnson_ef Member

    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
  3. FrankKalis Moderator

    Why?
    Enterprise Manager should only be available to Admins, not Power Users. And you can't stop someone with sa privileges anyway. There is a method, at best a kludge, including a hack to the system tables. However even this method will fool only less knowlegeable people.

    What are you trying to achieve?

    --
    Frank Kalis
    Microsoft SQL Server MVP
    http://www.insidesql.de
    Heute schon gebloggt?http://www.insidesql.de/blogs
    Ich unterstütze PASS Deutschland e.V. http://www.sqlpass.de)
  4. Adriaan New Member

    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.
  5. ranjitjain New Member

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

    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.
  7. vsnreddi New Member

    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]
  8. chaitu1385 New Member

    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


  9. satya Moderator

    Yes in SQL 2000 with EM flakiness it is not possible and you can only control their privileges with proper roles.

    Satya SKJ
    Contributing Editor & Forums Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
  10. amitm79 New Member

    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
  11. FrankKalis Moderator

  12. ranjitjain New Member

    <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=':p' />][<img src='/community/emoticons/emotion-4.gif' alt=':p' />]
  13. FrankKalis Moderator

  14. vsnreddi New Member

    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]
  15. satya Moderator

    Reference from KBAs
    http://support.microsoft.com/default.aspx/kb/889696
    http://support.microsoft.com/default.aspx?scid=kb;en-us;832955
    .. about the undocumented SP referred by Frank and keep in mind it might change or deleted in future releases.

    quote:Originally posted by FrankKalis

    No, I won't elaborate on this. If you want to find out, google for sp_MS_marksystemobject.
    This is undocumented stuff and I would seriously suggest you find some other solution.

    --
    Frank Kalis
    Microsoft SQL Server MVP
    http://www.insidesql.de
    Heute schon gebloggt?http://www.insidesql.de/blogs
    Ich unterstütze PASS Deutschland e.V. http://www.sqlpass.de)


    Satya SKJ
    Contributing Editor & Forums Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
  16. derrickleggett New Member

    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.

Share This Page