Creating New users in Oracle 21c

Granting Access: Creating New Users in Oracle 21c
Welcome, database adventurers! Today's quest: creating new users in Oracle 21c. Whether you're a seasoned Oracle scholar or a curious newcomer, this guide will equip you with the knowledge to safely grant access to your database kingdom.

First things first: Gearing Up

For this journey, we'll need our trusty tools:

SQL*Plus: Oracle's command-line interface for interacting with the database.

The Login Ritual (with a twist!)

1. Summoning SQL*Plus: Press the Windows button and search for "sqlplus."

2. Assuming the Throne (as SYSDBA): Here's the twist! Unlike traditional logins, type sys as sysdba and press Enter. Leave the password prompt blank.  This special syntax grants us ultimate power (with great responsibility!) to create users.

The User Creation Ceremony

1. Unveiling the Newcomer: Now for the incantation! Type the following command, replacing c##username with your desired username and yourpassword with a secure password:
SQL
create user c##username identified by yourpassword;

Use code with caution.
content_copy
2.Granting the Keys to the Kingdom: New users need some permissions to navigate the database. Issue this decree:
SQL
grant resource, connect, dba to c##username;

Use code with caution.
content_copy
This grants basic functionalities like connecting and managing database objects. You can customize permissions later based on specific user needs.

3.Sealing the Pact: Finalize the process with a commit; command to ensure changes are permanent.
Congratulations! You've successfully bestowed access upon a new user. Now they can connect to your Oracle 21c database using SQL*Developer or other tools.

Bonus Tip: Remember to replace c##username with a username that adheres to your organization's naming conventions.

Remember, with great power comes great responsibility! Granting DBA privileges should be done with caution, only for users who truly require full administrative control.

Further Exploration:

This guide provides a foundation for user creation. For deeper dives into user management and advanced permission control, refer to the official Oracle documentation: https://docs.oracle.com/cd/B13789_01/server.101/b10759/statements_8003.htm

Happy database adventuring!

Last update on Jul 09, 2024

Tags: oracle