Oracle Database Service Account


Kindly define the service account least privilege to add new oracle DB asset.

could we create new account different from SYS account for authentication?

And what are commands should the account run ?

thanks in advance

  • Hi Mahmoud,

    For an Oracle Asset, you can use a non-SYS service account and it would require the permissions "create session" and "alter user"

    create a service account C##SAFEGUARD identified by "password" default tablespace "USERS"
    grant create sessions to C##SAFEGUARD
    grant alter user to C##SAFEGUARD

    Oracle accounts are case sensitive in SPP and so these should be entered in all uppercase as well.

    If managing a SYS account then you should type SYSDBA in the As Privilege field otherwise Check Password for SYS would fail.