Oracle (1) authentication mechanism and user creation and modification

Oracle (1) authentication mechanism and three authentication mechanisms for User Creation and database modification: operating system verification Password File verification database verification note: sys users only need OS verification and password file verification. linux oracle start process lsnrctl start // sqlplus sys/oracle as sysdbasqlplus/nologconn sys/oracle as sysdbastartup www.2cto.com window oracle start Process lsnrctl start verifies the operating system by default, if the verification is successful, the password file is no longer verified and the path D: \ oracle \ product \ 10.2.0 \ db_1 \ database \ PWD + Instance name is not verified. to restore the ora sys password, you can set PWDorcl first. ora deleted and used commands to generate orapwd file = D: \ oracle \ product \ 10.2.0 \ db_1 \ database \ PWDorcl. ora password = 123456 entries = 10 select * from v $ pwfile_users; change the password of a common user alter User scott identified by tiger ** the oracle instance is not started and can also be logged on to create user create User username identified by password default tablespace Temporary tablespace Quota integer K | M | Limited on tablespace PS: create user kyle identified by kyle default tablespace kylespace Temporary tablespace Temp Quota 50 M on kylespace www.2cto.com Note: The following cannot use unlimited on Temp (because Temp is a Temporary tablespace, used for table sorting) create user kyle identified by kyle default tablespace kylespace Temporary tablespace Temp Quota unlimited on Temp modify alter user kyle identified by kyle default tablespace kylespace Temporary tablespace Temp Quota unlimited on kylespace author kyle8525_nsn