Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2002

    Unhappy Unanswered: locking a set of tables

    I have a tablespace I want read only. I have spent countless hours creating the perfect demo set of tables filled with all the data I need. I did this one other time and all my data was overwritten by someone who did not know what they were doing. Is there a way to lock the tables to where they can only be read by the User I created for them??? Help Please

  2. #2
    Join Date
    Jun 2001
    The Netherlands
    You basically want a set of tables that cannot be altered (updated, deleted from) by any other user thaen yourself.
    What you should do is create two schemas (or user account as some people call it).
    One schema, say A, is where you create and fill your tables. You give this schema a password you alone know.
    Create a second schema, say B, which your normal users will use. Now from schema A grant schema B select privilege on the tables from schema A. After that log onto schema B and create synonyms for the tables from schema A.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts