Default user privs
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Default user privs

  1. #1
    Join Date
    Apr 2002
    Posts
    61

    Default user privs

    I created a new user and by default the user is getting select on all tables of one of the schemas.
    Please provide me your feedback as to how to investigate this. When I checked sys.USER_TAB_PRIVS, I don't see anything granted to the new user, however, the new user was able to select data from one of the schemas.
    Thanks.

  2. #2
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    what privileges were granted to the user when it was created? what roles does the user have, and what privileges do the roles have?
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

  3. #3
    Join Date
    Apr 2002
    Posts
    61

    script used

    SQL> CREATE USER zzz IDENTIFIED BY zzz;
    SQL> GRANT create session TO zzz;

    Then the user was able to select data from one of the schemas.

  4. #4
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    are there public synonyms against the tables, by any chance?
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

  5. #5
    Join Date
    Apr 2002
    Posts
    61

    Never mind

    Found out that the schema objects have select grant to public, that is why the new user was able to select the data from the existing schema even though there was no explicit grants made to the new 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