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. Therefore, I separately added the permissions for tb_bil_acct_566, seq_bil_acct_his _
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. Therefore, I separately added the permissions for tb_bil_acct_566, seq_bil_acct_his _
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 $