dcsimg
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2009
    Posts
    18

    New user in oracle having access to all tables

    Hi,
    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?

    Thanks

  2. #2
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    4,165
    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_.
    this space intentionally left blank

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




×
We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.