DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: New user in oracle having access to all tables

  1. #1
    Join Date
    Apr 2009

    New user in oracle having access to all tables

    I have created a new user in oracle database as follows

    create new user u1 identified by u1;
    grant create session to u1;

    when I login with new user ,it has access to all tables in other schema except system and sys tables.
    i want to create a user who does not have access to any table on any schema.
    how it can be achieved?


  2. #2
    Join Date
    Nov 2000
    Pittsburgh, PA
    Any privilege that is granted to public is available to any user. the minimum privileges for a user are create session and connect.
    You should also make sure that O7_DICTIONARY_ACCESSIBILITY is set to false. otherwise ordinary users will be able to query
    data dictionary tables. Having said that there will always be tables and views that will be available to any user. For example any
    data dictionary table that starts with ALL_ or USER_.

Posting Permissions

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

Click Here to Expand Forum to Full Width