Oracle application records

Oracle Application Record 1. Delete the data in the oracle recyclebin table purge recyclebin 2. Enable and stop recyclebin alter system set recyclebin = off; the system has changed alter session set recyclebin = off; session has changed. 3. The system predefines the role. The role is a common role automatically created by the system after the database is installed. The following describes the predefined roles. You can use the following statement to query permissions of a role: SQL> select * from role_sys_privs where role = 'Role name'; 1. CONNECT, RESOURCE, and DBA are pre-defined roles mainly for backward compatibility. It is mainly used for database management. Oracle recommends that you design your own database management and security permission planning, instead of simply using these pre-roles. In future versions, these roles may not be pre-defined. 2. DELETE_CATALOG_ROLE, EXECUTE_CATALOG_ROLE, and SELECT_CATALOG_ROLE are mainly used to access data dictionary views and packages. 3. The EXP_FULL_DATABASE and IMP_FULL_DATABASE roles are used for data import and export tools. 4. AQ_USER_ROLE, AQ_ADMINISTRATOR_ROLEAQ: Advanced Query. These two roles are used for advanced oracle query. 5. SNMPAGENT is used for oracle enterprise manager and Intelligent Agent 6. RECOVERY_CATALOG_OWNER to create users with recovery databases. 7. HS_ADMIN_ROLEA DBA using Oracle's heterogeneous services feature needs this role to access appropriate tables in the data dictionary.