Solved

Grant access to READ-ONLY Oracle Database

Posted on 2009-06-30
3
1,229 Views
Last Modified: 2013-12-19
I am the owner of the Oracle schema. I tried to grant read only access of all my objects to other users.  However, when other users login they can not see all the objects (e.g the definitions of tables or views) on their session.  They are using either Toad or Oracle SQL Developer to view the database objects. How do I give them access to view the definitions of my OBJECTS?
0
Comment
Question by:Severcorr
3 Comments
 
LVL 73

Assisted Solution

by:sdstuber
sdstuber earned 100 total points
ID: 24747109
Some of your privileges will make the all_xxxx views work for the other users.
but some objects will require access to dba_xxxx views

by default toad doesn't use dba_xxxx views, you must configure it to check for access to those views
0
 

Author Comment

by:Severcorr
ID: 24748868
I am not concerning about the Dictionanray tables or views. My question is how come other users can not see the tables or views that I created in their sessions. What priveleges do I need to gave for them to see?
0
 
LVL 34

Accepted Solution

by:
Mark Geerlings earned 400 total points
ID: 24749210
"how come other users can not see the tables or views that I created in their sessions".

Oracle does not support creating objects "in their sessions".  If you have the "create any table" system privilege (or the DBA role which includes this system privilege) you can create objects in any schema (but not in another session).

For other users to see objects in your schema, two things are required:
1. You must "grant select on [object_name] to [other users or roles they have]"
2. They must either use fully-qualified object names: [schema].[object_name] or there must be a synonym for your objects.  This could either be a public synonym (that works for all other users) or it must be a priviate synonym in each uers's schema.

Synonyms (whether public or private) do *NOT* take the place of grants.  Synonyms just allow for objects to be referenced with shorter names, but if there is no grant on the actual object the synonym refers to, the other user will still get the "object does not exist" error.
0

Featured Post

What Is Threat Intelligence?

Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

Join & Write a Comment

Oracle Apps Profiles option: A user profile is a set of shifting options that alter the way one runs an application. A value is set for each option under the user's profile when the Oracle application user logs on to any responsibility or changes…
Messaging apps are amazing tools with the power to do a lot of good, but the truth is the process of collaborating with coworkers requires relationships established through meaningful communication - the kind of communication that only happens face-…
This video shows information on the Oracle Data Dictionary, starting with the Oracle documentation, explaining the different types of Data Dictionary views available by group and permissions as well as giving examples on how to retrieve data from th…
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…

708 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now