Link to home
Start Free TrialLog in
Avatar of Pau Lo
Pau Lo

asked on

oracle read only unrestricted account

We need to create a read only account for auditing purposes to an oracle database. The user needs full access to everything, but only at read only level. They have select any table, but claim that still doesn't allow them to have full access to everything. Is there any other roles/privs that could be assigned so they can do there checks without running the risk of changing data?
Avatar of Pau Lo
Pau Lo

ASKER

I wasnt sure if some tables or views are still protected from access even if they havd select any table type priveleges
ASKER CERTIFIED SOLUTION
Avatar of Geert G
Geert G
Flag of Belgium image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
wrapped items they'll never have access to
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Pau Lo

ASKER

Excuse my ignorance but what are "wrapped items"?
>>what are "wrapped items"?

semi-encrypted source code.

I say semi-encrypted because I've heard that it was finally cracked and the code could be decrypted.

It is a way to 'hide' your pl/sql code.

wrap is an OS executable that will create a file that can be loaded in the database.

The online docs...  always a great place to start.