oracle-New User

Question Answer:

1. Why create a new account using the SYS account.

A: Because SYS has DBA authority, and SYS is already in existence after installing Oracle, the password can be entered at random.

2. Why not create a user using the SQL language?

A: All the way to Rome, as long as the purpose can be achieved.

3.sys is the Oracle built-in Administrator account for the system, what is the difference?

A: System is a general administrator built into the database, and any user you create manually will be similar to that user after being granted the DBA role.

SYS uses the super user of the database, many important things in the database (data dictionary table, built-in package, static data dictionary view, etc.) belong to this user, SYS user must log in as SYSDBA identity.

System users log in as SYSDBA is sys, accurately, any user logged in as SYSDBA is SYS, this point, you log on after the show user can verify.

1. Login SYS Account

If you have not changed the password of the SYS account, you can fill in the password in the login sys account interface. The following has been "abc123" as a password login once. Note here that "connect as" selects "SYSDBA".

Figure 1: Landing window

2. Fill in the User name password

In the Objects panel, right-click New ... in the Create User dialog box that appears, fill in the user name, password. The default table space, temporary tablespace, and overview diagram are selected as shown. Then "Apply".

Figure 2: Creating a user window

3. Give new user name permission

Figure 3: Assigning permissions to a role so that users can log in, create tables, create sequences, create stored procedures, and so on.

Figure 4: Permissions to create a view for user assignment

4. Then test the landing:

Figure 5: User Login interface

End!!!

oracle-New User