Windows10 "Sqlplus/as sysdba" execution prompt no permission to resolve

ORA_DBA: is a unique user of Oracle, is Super Administrator privilege, built DBA it has the highest authority to manage the database.

Note: You need to run CMD as an administrator, or the 4th step will fail ( Click Start, enter cmd, right-click Run as Administrator )

1. Use the command to view the current system User: NET User

This is all the users in the current system.

2. View user groups

NET localgroup– View user group;

3. View the specific users under the ORA_DBA user group:

net localgroup ora_dba;

There is no first step to find the native administrator user.

4. Add the native administrator user (remember the user set up when the system logs in) to the ORA_DBA user group:

net localgroup ora_dba Administrator/add;
You can also add a user group under the group
net localgroup ora_dba Administratos/add;

5. At this point, the successful execution of "Sqlplus/as sysdba"

Windows10 "Sqlplus/as sysdba" execution prompt no permission to resolve