Granting the SYSBACKUP Privilege

As a database administrator, you can grant the SYSBACKUP privilege to any database user. When you do so, an entry is made for that user in the password file.

To grant the SYSBACKUP privilege to an existing user:

  1. Log into Oracle Enterprise Manager Database Express (EM Express) as user SYS. Be sure to select the as sysdba check box on the Login page.
  2. From the Security menu, select Users.
  3. On the Users page, click the name of the user to whom you want to grant the privilege.
  4. On the Account Summary page, in the Privileges tab, click Edit.
  5. In the Alter Privileges dialog box, scroll to the SYSBACKUP privilege in the left-hand list, select it, and then click the Right-Arrow (>) button.

    The SYSBACKUP privilege appears in the right-hand list.

  6. Click OK.