Oracle Licensing, table backup, user management

User Management Creation User: Create username identified by password;    Modify password: Alter user username identified by password;    Activate User: Alter user username account unlock; Delete users: Drop user user name; User Rights Management1, Authorization permissions (connect, resource, DBA) grant permission 1, permission 2,... to username; 2, REVOKE permissions revoke permissions 1, permission 2,... from user name; 3, important permissions require the user to exit and log back on before loading data table permissions Management1, Authorization permissions (all, select, Update, DELETE, INSERT, alter (only table structure can be modified)) grant permission 1, permission 2,... on table name to user name; 2, revoke permissions 1, permissions 2,... on table name from user name; 3, table permissions in addition to the drop, create these 2 permissions belong to the owner, other permissions can share Select, INSERT, UPDATE, DELETE, alter data backup1, full table backup CREATE table secondary table name as Select*The name of the From Main table; 2, data internal backup CREATE table secondary table name as select Ename,empno||Deptno,... from Sun_emp; 3, data backup is full-field full data replication, but constraints do not replicate data synchronization updates the first step: delete the data from the secondary table delete from secondary table; Step two: Insert the main table information insert into secondary table select* from the main table;

Oracle Licensing, table backup, user management