Collections:
Create a New User Account in Oracle
How To Create a New User Account in Oracle?
✍: FYIcenter.com
If you want to create a new user account, you can log in as SYSTEM and use the CREATE USER command as shown in the following example:
>.\bin\sqlplus /nolog SQL> connect SYSTEM/fyicenter Connected. SQL> CREATE USER DEV IDENTIFIED BY developer ACCOUNT UNLOCK; User created.
Note that CREATE is a SQL statement, so you need to terminate it with ";". This command creates a user called "DEV", with a password of "developer". You can test this account by log in with DEV from SQL*Plus.
⇒ Change User Password in Oracle
⇐ Show All User Accounts in Oracle
2019-07-21, 1542🔥, 0💬
Popular Posts:
What Happens to Your Transactions When ERROR 1205 Occurred in MySQL? If your transaction receives th...
How to connect SQL Server Management Studio Express to SQL Server 2005 Express in SQL Server? Once y...
Where to find answers to frequently asked questions on PHP Connections and Query Execution for MySQL...
How To Use DATEADD() Function in SQL Server Transact-SQL? DATEADD() is a very useful function for ma...
How To Replace Given Values with NULL using NULLIF() in SQL Server Transact-SQL? Sometime you want t...