Re: Simple Newbie Question - table creation
From: Murali Kazhipurath <murali_at_jps.net>
Date: 1996/10/30
Message-ID: <01bbc61e$cc27cea0$65646464_at_licorice>#1/1
Date: 1996/10/30
Message-ID: <01bbc61e$cc27cea0$65646464_at_licorice>#1/1
What you need do is create public synonyms. Granting permissons alone will not help this.
Murali
-- Murali Kazhipurath Technical Consultant Kaustubam (Database and Internet Solutions Provider) murali_at_jps.net Phone # (916) 773 1918 Kennon L. Whitehead <kennon_at_mail.pernet.com> wrote in article <01bbc5fb$ff4cb160$a400e5cd_at_kennon>...Received on Wed Oct 30 1996 - 00:00:00 CET
> 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> ;
>
>