Tag: Grant
Solution:
Grant select, insert, update, delete on bookmarks. * to [email protected] 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.
Http://blog.csdn.net/zhangtian0913/archive/2009/03/09/3973484.aspx
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 $ '[@ [email protected] 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 $
Ora-00942 tables or views encountered during storage do not exist