Permission require running sqlplus /nolog (Windows)

In Windows platform, if the login user ID has local administrator right, can it run a script

sqlplus /nolog
connect / as sysdba
alter database begin backup;

sqlplus /nolog
connect / as sysdba
alter database end backup;
Keng0499Asked:
Who is Participating?
 
Guy Hengel [angelIII / a3]Connect With a Mentor Billing EngineerCommented:
sqlplus /nolog
 does not need any permissions, it's just to start the sqlplus command line (without actually connecting..., hence no permissions needed)

connect / as sysdba
this does require the local user to be in the ORA_DBA group:
https://docs.oracle.com/cd/B28359_01/win.111/b32010/authen.htm

which also enables this statmenet, as SYSDBA has all powers
alter database end backup;
0
 
Keng0499Author Commented:
thank you
0
All Courses

From novice to tech pro — start learning today.