Oracle Synonym Statement Backup

--Create synonyms
Create synonym t_system_userdepartment for Xtzl. T_system_userdepartment;
--Query synonyms
SELECT * from SYS. all_synonyms WHERE synonym_name= ' t_system_post ';
--Query the synonyms under the current user
SELECT * from user_synonyms;
--Authorization inquiry
Grant SELECT on Tabel1 to SECMGT
-REVOKE permission;
Revoke insert on t_system_userdepartment from SECMGT;
--Query the serial number under the current user
SELECT * from User_sequences;
--Test query
Select A.*, rowid from T_system_department A;
--Delete test
Delete from t_system_department where id= ' 1 ';
--Test insert
Insert into t_system_department (Id,deptname,parentid,state,orderno) VALUES (1, ' Test Department ', ' 0 ', ' Enable ', ' 123 ');
--Delete test
drop table t_system_userdepartment;

Oracle Synonym Statement Backup