Kbase 15073: Oracle: How to create an ORACLE User.
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
9/7/2004 |
|
Status: Unverified
GOAL:
How to create an ORACLE User.
FIX:
The ORACLE RDBMS comes with two users already created after the product has been installed. These users are SYS and SYSTEM. The SYS account usually is identified by the password "oracle" and the SYSTEM account is identified by the password "manager". To create additional users you can either use the sqlplus or sqldba utilities. The format for the create user command is as follows:
create user <username> indentified by <password>;
Example: CONDOR> sqlplus system/manager
SQL>
SQL> create user gerhardt identified by test;
User created.
SQL>
SQL> exit