When Oracle installs and creates a database instance, three users are automatically generated: sys, system, and scott.
1.sys user super administrator (equivalent to SQL SA, MySQL root), has the highest privileges of Oracle, has the SysDBA role, has the permission to create database, and the password is manager by default. (What is said here is not right, I tested that the manager cannot log in, and the password is the password I set when I installed it)
2. The system user is the operation administrator, with permissions second only to sys, and has the role of sysoper(ate); system does not have the permission to create database, and the other permissions are the same as sys.
3. Scott user ordinary user, the default password is tiger, the user default is locked, and can be unlocked with system
Note: For general database maintenance, you can use system user login.
|
Posted on 8/14/2016 10:53:33 PM
|
|
|
