[ACCEPTED]-Oracle Create View issue-ora-00942

Accepted answer
Score: 11

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.

Score: 8

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).

Score: 0

Probably because you do not have access 2 to the table or view

Query grant privileges 1 on object to user;

More Related questions