Re: Simple Newbie Question - table creation
From: Kennon L. Whitehead <kennon_at_mail.pernet.com>
Date: 1996/10/30
Message-ID: <01bbc5fb$ff4cb160$a400e5cd_at_kennon>#1/1
Date: 1996/10/30
Message-ID: <01bbc5fb$ff4cb160$a400e5cd_at_kennon>#1/1
Jim McRee <mcree_at_orionsci.com> wrote in article
<32722904.2585_at_orionsci.com>...
> 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.
Also, you need to grant them select on the tables if you haven't. Ex.
GRANT SELECT ON <TABLE NAME> TO PUBLIC ;
They should be able to describe them using full table name:
DESCRIBE <OWNERE>.<TABLE NAME> ; Received on Wed Oct 30 1996 - 00:00:00 CET