Should a user be created with Select / Read authorizat into GRC database

[Former Member]

Hi,

Project team wants the access to the GRC 5.3 database of non production system. The access should be with only read/select authorization on few tables.

So would you please suggest

1 : Should the access to the database be given with select authorization ?

2 : If it is recommended then how to create such user id in database with only read/select authorization.

2 : Or is there any other way so that the project team can get the required data through the GRC application itself.

Kindly guide us.

Thanks & Regards

Girish Garje

[fidel_vales · Accepted solution]

Hi,

Are you talking to provide access at DB level?

You should not do so.

• For starters you could be in violation of the license (if you adquired Oracle from SAP) see note 581312 for more information

Probably there is a way of getting the required information from SAP itself, but probably this is not the correct forum to ask that question.

[Former Member]

Hello,

Thanks both of you.

[stefan_koehler]

Hello Girish,

you can create a oracle database user with the "SELECT ANY TABLE" privilege.

Regards

Stefan