Re: Simple Newbie Question - table creation
From: David J. Roth <droth_at_sii.com>
Date: 1996/10/28
Message-ID: <01bbc4d2$2438d060$8b0ebe9b_at_droth.sii.com>#1/1
Date: 1996/10/28
Message-ID: <01bbc4d2$2438d060$8b0ebe9b_at_droth.sii.com>#1/1
You need to grant access to the tables.
E.g.,
GRANT SELECT ON new_table TO username;
or
GRANT ALL ON new_table TO username.
Users will now be able to do something like
DESC owner.new_table
That is, they will have to give the owner of the table explicitely.
The alternative is to use synonyms.
CREATE PUBLIC SYNONYM new_table FOR owner.new_table.
Now DESC new_table should work for anyone with the GRANTed privs
-- David J Roth (My own opinions) Jim McRee <mcree_at_orionsci.com> wrote in article <32722904.2585_at_orionsci.com>...Received on Mon Oct 28 1996 - 00:00:00 CET
> 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.
>