Αποτελέσματα Αναζήτησης
1 Αυγ 2020 · The result will be "ORA-00942: table or view does not exist" even though user2 does have insert and select privileges on user1.customer table and is correctly prefixing the table with the schema owner name. To avoid the problem, you must grant select privilege on the sequence: grant select on seq_customer_id to user2; answered Mar 22, 2016 at 21:19
By default, stored procedures and SQL methods execute with the privileges of their owner, not their current user. If you created a table in Schema A and the function in Schema B, you should take a look at Oracle's Invoker/Definer Rights concepts to understand what might be causing the issue.
1 Ιουν 2023 · If you’re getting the ora-00942 table or view does not exist in Oracle 12c, then it could be caused by this situation: Another user has a table and a sequence; One of the columns in the table has a default value of the sequence.nextval; You have the right privileges on the table
9 Σεπ 2024 · ORA-00942. table or view object_name does not exist. object_name: The table or view name specified as SCHEMA.OBJECT_NAME, if one is provided. Otherwise, it is blank. Cause. The specified table or view did not exist, or a synonym pointed to a table or view that did not exist.
23 Μαρ 2019 · ORA-00942 means that SQL engine found no table or view in your usable scope. In other words, table or view does not exist.
Learn the cause and how to resolve the ORA-00942 error message in Oracle. You tried to execute a SQL statement that references a table or view that either does not exist, that you do not have access to, or that belongs to another schema.
4 Απρ 2016 · check that an existing table or view name exists. contact the DBA if the table needs to be created or if user or application privileges are required to access the table. The following is the example to address your situation. It shows how grant SELECT object privilege and how to create synonym.
