Oracle Self-study notes

3 Default users in OracleSYS Change_on_install [as SYSDBA] System Manager Scott Tiger Data Dictionary View what system permissions the current user hasSELECT * from User_sys_privs; View what object permissions the current user hasSELECT * from User_tab_privs; Create a userCreate user Wangwu identified by WANGWU; System PermissionsGrant Create session to WANGWU grant CREATE table to WANGWU Grant unlimited tablespace to Wangwu; Reclaim Permissions... revoke unlimited tablespace from WANGWU; authorize to all usersGrant create session to public; Grant create any table to public;
Object PermissionsGrant SELECT on Mytab to Lisi; Grant all on Mytab to Lisi;
... revoke all on mytab from Lisi; Set Display width: Set Linesize 400 controls the permissions on the table column, for example: Control Lisi update permissions on MYTAB table Name column Grant Update/insert (only two, query and delete cannot control to column) Delete (name) on Mytab to Sili; Queries which columns the current user has permissions on: SELECT * from User_col_privs; Transfer of permissions:Grant alter any table to Lisi with admin option; Grant SELECT on TableName to Lisi with GRANT option; role:Create role Myrole grant create sessions to Myrole; Drop role Myrole; Note that some system permissions cannot be directly assigned to roles such as create any table, alter any table, drop any table, which belongs to a user, and the role does not belong to one. three kinds of authentication mechanisms for Oracle databases:1. Operating system validation 2. password file Validation 3. Database Verification Linux Start Oracle database process: 1.LSNRCTL start monitor 2.sqlplus sys/oracle as Sysdba 3.startup Restrict User:User lock: Alter user name account lock user unlock: Alter user username account unlock user password immediately expires: Alter user username password expire