Simple Newbie Question - table creation

Jim McRee <mcree_at_orionsci.com> wrote:

Jim,

There is a couple of things you need to do to give access to other users, the first concept you need to realise is the idea of a users schema. Each user of Oracle has their own schema in your case if your Oracle user name is jim then your schema is also jim, so when you create a table say customer for another user to access that table you have to grant access to the user say fred.

Now for fred to see your table fred would have to type 'desc jim.customer'.

If fred did not want to use the user name prefix 'jim.customer', fred could create a synonym called customer based on the table jim.customer.

I know this sounds a bit confusing, but the use of the schema concept makes the Oracle database very flexible as far as naming objects go.

Hope this helps...

Gordon
>I am brand-new to Oracle - please excuse the simple-ness of this
>question.
>
>I have created tables, but I am the only user who can see them.
>Whenever another user logs in, and types "describe table_name" for
>example, the object does not exist. What do I need to do (or should I
>do) to make them available to all users. Right now, I am just logging
>in and creating a table.
>
>Thank you for any help you can provide.
>
>Jim.
Received on Sun Oct 27 1996 - 00:00:00 CEST