Oracle Database Operation Guide: Quickly Create Query Users

Oracle Database Operation Guide: Quickly Create Query Users

In Oracle database, in order to improve the efficiency and security of database management, different users are usually assigned different permissions and roles. In order to create a user with query permissions in the database, here are some specific code examples and steps:

Step 1: Log in to the Oracle database
First, use administrator privileges The user logs in to the Oracle database in order to create a new query user. Enter the following command at the command line:

sqlplus sys as sysdba

Then enter the system administrator password to log in to the database.

Step 2: Create a new user
In Oracle, you can use the CREATE USER statement to create a new user. The following is a sample code:

CREATE USER new_user IDENTIFIED BY password;

Here, new_user is the username of the new user and password is the password of the new user.

Step 3: Assign query permissions
In order for the new user to have query permissions, we need to grant SELECT permissions to the user. You can use the following GRANT statement:

GRANT SELECT ON schema.table TO new_user;

Here, schema represents the schema where the table is located, and table represents the specific table name. Through this statement, new_user will be granted query permissions on the specific table.

Step 4: Grant connection permissions
In addition to query permissions, we also need to ensure that the new user has the permissions to connect to the database. Grant connection permissions using the following statement:

ALTER USER new_user ACCOUNT UNLOCK;

This statement will unlock the new user's account so that they can connect to the database.

Step 5: Exit and test
After completing the above steps, you can exit the administrator user and log in to the database using the newly created query user. You can use the following command to exit the database:

exit;

Then, use the newly created user to log in to the database:

sqlplus new_user/password

After successful login, try to execute the query statement, for example:

SELECT * FROM schema.table;

If the data can be queried successfully, it means that the new user has been successfully created and has query permissions.

Through the above steps, we can quickly create a user with query permissions and ensure the efficiency and security of database management. I hope the above operation guide will be helpful to you.

The above is the detailed content of Oracle Database Operation Guide: Quickly Create Query Users. For more information, please follow other related articles on the PHP Chinese website!