ORA-00942 tables or views encountered during storage do not exist

ORA-00942 tables or views encountered during storage do not exist

Solution:

Grant select, insert, update, delete on bookmarks. * to bm_user @ localhost identified by 'Password'

Authorization statement: Grants the XXX select, insert, update, and delete permissions to the bm_user table.

Log on to the system as sys and grant the select and delete sys. fga_log $ permissions to the system. Otherwise, the following stored procedure may be added.

SQL> grant select, delete on sys. fga_log $ to system;

Cause:

Later, I found out that if the user has a dba role, the permissions contained in the role will not be inherited in the stored procedure; so I separately granted explicit permissions to tb_bil_acct_566, seq_bil_acct_hisid_566.nextval, etc, solve the problem.

Where can I see the Authorization result of grant authorization?

Grant select, delete on sys. fga_log $ to system; -- which base table is changed? -- Dba_tab_privs

Select * from dba_tab_privs where grantee = 'system' AND TABLE_NAME = 'fga _ LOG $ '[@ more @] grant select, delete on sys. fga_log $ to system; -- which base table is modified? -- Dba_tab_privs

Select * from dba_tab_privs where grantee = 'system' AND TABLE_NAME = 'fga _ LOG $