Hide Tables

• • Reply

  16 years ago

  by mejaz

  Mohammed Ejaz

  , Pakistan

  Joined 16 years ago

  Hi,
    Is there is any way to hide a table in the database.
    I have a logon table and i don't want to show this table to the users so is there is any way to hide a table in the database for the users?
  

  
  Thnx in advance

  Report abuse
• • Reply

  15 years ago

  by Sekar Sai

  Sekar Sai

  , United States

  Joined 15 years ago

  Hi
  You cannot hide the table if all others are using the same table owner schema/user for login.
  If others are using different login then
  1. You have to revoke the PUBLIC privileges granted on this table.
  2. You have to revoke the PUBLIC access of other users/schema,roles which may affect the production.
  You cannot hide the table from some of the default role like DBA,EXPFULLDB,etc... based privileged users.

  Report abuse
• • Reply

  15 years ago

  by auro2u

  auro2u

  , United States

  Joined 15 years ago
  how do i hid a table related to a database in a asp page.
  Report abuse