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.
2019-07-21, 809👍, 0💬
Popular Posts:
Where to find MySQL database server tutorials? Here is a collection of tutorials, tips and FAQs for ...
How to run Queries with "sqlcmd" tool in SQL Server? "sqlcmd" is a client tool that you can use to i...
How To Create a Stored Function in Oracle? A stored function is a function with a specified name and...
How To Recreate an Existing Index in SQL Server? If you want to change the definition of an existing...
How To Convert Numeric Values to Integers in SQL Server Transact-SQL? Sometimes you need to round a ...