Skip to Content
avatar image
Former Member

Oracle DB Administration User without Access to Business Data

Hi,

I'm currently evaluating the options to have an database administration user for an SAP system running with Oracle that allows me to use all the brtools functionality (backup, restore, tablespace admin, start/stop DB, etc.) (also via sqlplus) but denies reading any business data (e.g. via select in sqlplus) from the DB.

Do you have any ideas how to implement this data security requirement?

Thanks,

Stefan

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • avatar image
    Former Member
    Jul 16, 2012 at 01:35 PM

    Hi Stefan,

    You can set the privileges by creating new user at Oracle level and give the required permissions to that. Additionally, you can set the user security by configuring SQLPLUS_PRODUCT_PROFILE table, also. Please note that do not modify the SAP database owner. Just keep the password in secure and create a new user.

    By doing so, you brtools will not be affected and can be used without any other modification.

    Best regards,

    Orkun Gedik

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jul 16, 2012 at 01:55 PM

    Isn't it there already? OPS$ users?

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jul 17, 2012 at 06:21 AM

    Please read the following:

    SAP on Oracle - Security

    Regards

    Roman

    Add comment
    10|10000 characters needed characters exceeded