Database Reference
In-Depth Information
SQL> grant sysbackup to backup;
Grant succeeded.
The user that is granting the SYSBACKUP privilege must have the ability to use the
GRANT SQL command,
When a database is created, a SYSBACKUP account is created with the SYSBACKUP
privilege granted to it. The account is locked when it is created. Thus, to use the SYSBACKUP
account you would need to unlock it using the ALTER SYSTEM command and then you
should change the password using the ALTER SYSTEM command.
Don't Use Default Accounts
It is a best practice to never use default accounts. Never use the SYS account, for exam-
ple, unless Oracle tells you to. Never use accounts like SYSBACKUP because they are
commonly known default account names, and thus subject to hacking attempts. You can-
not drop the SYSBACKUP account, so you will want to make sure that you keep it locked
at all times.
When you connect to the database using an account that has the SYSBACKUP privilege,
you will actually be logged into the database SYS schema as the SYSBACKUP session
user. This can be seen via a query to SYS_CONTEXT as seen here:
SQL> select sys_context('USERENV', 'CURRENT_SCHEMA') from dual;
sys_context('USERENV','CURRENT_SCHEMA')
----------------------------------------------------------------
SYS
SQL> select sys_context('USERENV', 'SESSION_USER') from dual;
SYS_CONTEXT('USERENV','SESSION_USER')
---------------------------------------------------------------
SYSBACKUP
When you use RMAN to connect to an account with SYSBACKUP privileges, you don't
need to do anything special from the command line to indicate that you want to use the
SYSBACKUP privileges. So, connecting to an account called BACKUP would be as easy as
this:
C:\Users\Robert>rman target backup/backup
Recovery Manager: Release 12.1.0.1.0 - Production on Sun Jun 1 14:40:31 2014
Copyright (c) 1982, 2013, Oracle and/or its affiliates. All rights reserved.
connected to target database: ORCL12C (DBID=670264325)
Search WWH ::
Custom Search