How to grant all privileges to a user in Oracle?

To grant all permissions to an Oracle user, you can follow these steps:

1. Log in to the Oracle database with a user who has the sysdba role.
2. Execute the following command to create a new role and grant it all system privileges:

CREATE ROLE dba_role;
GRANT ALL PRIVILEGES TO dba_role;

1. Grant the new role to the target user using the following command:

GRANT dba_role TO <目标用户>;

Note: Please replace with the actual username for whom you want to grant all permissions.

1. The target user now has all system privileges. You can verify using the following command:

SELECT * FROM USER_ROLE_PRIVS WHERE GRANTED_ROLE = 'DBA_ROLE';

This command will return a record confirming that the target user has been granted the dba_role role.

Please be aware that granting users all permissions may pose security risks. Before granting users all permissions, ensure they are properly evaluated and only grant them the minimum permissions required.