[ACCEPTED]-Oracle Create View issue-ora-00942
Yes, you have (and always should) to explicitly 4 grant access to objects in another schema.
GRANT SELECT ON user2.table TO user1
Though 3 you're logged in as "the dba account" (SYS, I'm 2 assuming), the CREATE statement is for the 1 user1 schema specifically.
You can do CREATE OR REPLACE FORCE VIEW 6 ...
That will create the view despite the 5 lack of privileges, but the view would not 4 be usable unless the privileges are granted. It 3 is a solution that can be useful if privileges 2 will be granted later (eg in some automated 1 build script).
Probably because you do not have access 2 to the table or view
Query grant privileges 1 on object to user;
More Related questions
We use cookies to improve the performance of the site. By staying on our site, you agree to the terms of use of cookies.