Re: [Q] table names

In oracle database, there is a schema and an object. stark that you created is a schema and tab_name1 and tab_name2 are objects. All users can access the table
without adding stark by creating synonym, for example:

        "Create Public Synonym tab_name1 for stark.tab_name1" If a user access with tab_name1 without schema, it means that user is accessing tab_name1 table which owner is stark.

I hope this is useful for you.

Regards,

Daniel AS

vlpa_at_daleen.com wrote in article <6ms4f4$16i$1_at_nnrp1.dejanews.com>...
> Hello,
>
> all the tables in our system are labeled as
>
> stark.tab_name1
> stark.tab_name2
>
> and so on where 'stark' is like a prefix to any table
> name.
>
> In informix when issue a query like
> select * from tab_name1
> it works in Oracle it does not because I have to qualify the
> table name like stark.tab_name1.
>
> Is there a default I can set so for any user who logs in into
> the database -- the server will assume that he needs to append
> stark to every table name that is not provided as <some name>.<tab name>
>
>
> Thanks in advance,
> Vladislav
>
> -----== Posted via Deja News, The Leader in Internet Discussion ==-----
> http://www.dejanews.com/ Now offering spam-free web-based newsreading
>
Received on Thu Jun 25 1998 - 01:16:09 CDT