April 7th, 2004, 04:12 AM
|
|
Registered User
|
|
Join Date: Mar 2004
Posts: 25
Time spent in forums: 54 m 50 sec
Reputation Power: 0
|
|
|
DBA--- View creation problem
To be simple, say I have two Users having some schemas as below,
Code:
User1 (privilage: connect, resource, dba)
table1
view1 (based on select * from table1)
User2 (privilage: connect, resource, select on everything of User1)
When I log in as User2, this statement works
Create table table1 as select * from User1.table1;
However, this won't with the following error message
Create or replace view1 as select * from User1.view1;
or even
Create or replace view11 as select * from User1.table1;
Error: table or view doesn't exist (the User1's table or view).
1. What am I doing wrong, plz help.
2. In actuall, table/view of User2 have restricted records of User1's, based on certain condition. Is this the right approach of restricting records to a user? i.e.to User2.
Thanks for every second of your help 
|
Dev Shed Forums Sponsor:
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
