CODEWITHSUNDEEP
javajsonoracle-databaseoracle12c
joseph francis
joseph francis

Reputation: 41

SODA oracle 12 ,granting SODA_APP

I am trying to grant SODA_APP role as per SODA with JAVA

but this throws the following error in SQL developer

grant SODA_APP to IM_SIGIL_USR
Error report -
ORA-01924: role 'SODA_APP' not granted or does not exist
01924. 00000 -  "role '%s' not granted or does not exist"
*Cause:    Either the role was not granted to the user, or the role did not 
exist.
*Action:   Create the role or grant the role to the user and retry
 the operation.

Should there be any roles added while installation?

Upvotes: 1

Views: 593

Answers (1)

Max Orgiyan
Max Orgiyan

Reputation: 131

Which release are you on? If you're on 12.1.0.2 you need to install patch 20885778: https://support.oracle.com/rs?type=patch&id=20885778. That'll make the SODA_APP role available.

On subsequent releases, 12.2.0.1 and above, this is not required and SODA works out of the box, so you should be able to grant SODA_APP without having to install anything.

Upvotes: 1

Related Questions