Re: ORACLE7 Table Ownership problem

>Subject: Re: ORACLE7 Table Ownership problem
>From: hackneyd_at_ix.netcom.com (Douglas Hackney)
>Date: 25 Jan 1995 06:05:53 GMT
>Message-ID: <3g4po1$qb0_at_ixnews3.ix.netcom.com>
 

>In <1995Jan24.155934.3737_at_pfizer.com> "Mark J. Alberti"
><malberti_at_pfizer.com> writes:
 

>>
>>Hi. I have recently implemented a PowerBuilder 3.0a application where
 the
>>data resides in Oracle7 on a Sun Sparcserver running Solaris 2.3. The
>>application works fine, but now I'm trying to set up security on Oracle
 by
>>defining individual user IDs that are attached to Oracle roles. The
 problem
>>is that I defined my Oracle tables through the PowerBuilder database
 painter
>>with the Oracle "system" ID. Everything works fine when I sign on with
 "
>>system" because "system" owns the tables. If I sign on with another
>>authorized ID, the application will not execute any of the SQL
 statements
>>defined in my datawindows. Oracle is looking for a high level
 qualifier of "
>>system" because the current user is not the owner of the tables. Is
 there a
>>way around this problem without adding the "system" qualifier (e.g,
 system.
>>location) to each table that is referenced in my datawindows? Should I
 be
>>using Oracle security in this situation or should I implement security
 on an
>>application level? Any ideas would be helpful.
>>Thanks!
>>Mark
>>
 

>Try setting your tables to "public", then any logon can see them.

-- 
--------------------------------------------------------------------


>Doug Hackney                                  hackneyd_at_ix.netcom.com


--------------------------------------------------------------------

Setting to public ==>  GRANT SELECT ON tablename TO PUBLIC;

This will work but you have created another headache for your self!  The
tables were probably created in the SYSTEM tablespace.  If so you will end
up with lots of fragmentation which will lead to poor performance which
will lead to the need to defragment and defragmentation of the SYSTEM
tablespace is a pain the the A.

As a general rule of thumb,  only the tables created by Oracle and owned
by SYS should reside in the SYSTEM tablespace.

David Roth
Carty Mailloux Consulting                        All opinions expressed
are my own.
UNIX Client/Server System Integrators      Please that them for what they
are 
(508) 392-1300x20                                  worth.