> 
> 	I had a whole bunch of tables with some data in
> them on one Oracle 7.3 server on NT, I exported them out to
> a .dmp file, and imported them into a different 7.3 
> Oracle server on Solaris.  Now, I can do selects and
> everything else I want to do, in SQL Plus, but my Netscape
> LiveWire apps can't select on them.  I thought it could
> be a tablespace issue so I dropped one of the tables that
> didn't have any data in it and created it.  Now I can
> select on it from everywhere, including my LiveWire app.
> Could something be attached to the tables due to the
> export from NT into Solaris?
> 
> Puzzled in K.C.
> John
> -- 
> 
It sounds like permissions were not correctly carried over
from NT to Solaris. First, check the log files from both
the export and the import for any errors. Next, look at
the permissions on the LiveWire app:

SELECT * FROM DBA_ROLE_PRIVS WHERE GRANTEE = 'LIVEWIRE';
SELECT * FROM DBA_SYS_PRIVS WHERE GRANTEE = 'LIVEWIRE';
SELECT * FROM DBA_TAB_PRIVS WHERE GRANTEE = 'LIVEWIRE';
SELECT * FROM DBA_ROLES;

See if there are any differences between the NT and the
Solaris from the above SQL statements.


-Ari Kaplan
Independent Oracle DBA Consultant

<-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><->
<-> For 80+ Oracle tips, visit my Web Page:                       <->
<->                                                               <->
<->              www.arikaplan.com                                <->
<->                                                               <->
<->             email: akaplan@interaccess.com                    <->
<-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><->

Back to Ari Kaplan's Home Page m">Back to Ari Kaplan's Home Page