EBS Customizations (MOSC)

MOSC Banner

Read Only Apps Schema In R12.2

edited Jun 2, 2015 11:39AM in EBS Customizations (MOSC) 6 commentsAnswered

Hello Gurus,

Need your help. Can you please guide me in creating a Read-only user which will have similar access as APPS in E-Business Suite Release R12.2.x

The way we had been doing in earlier release of EBS seems to be not working on R12.2.

Following is the way we used to do in release 11.x  12.1.x

SELECT 'GRANT '

|| DECODE(O.OBJECT_TYPE,'TABLE','SELECT','VIEW','SELECT','EXECUTE')

|| ' ON '

|| DECODE(O.Owner,'PUBLIC','',O.Owner || '.')

|| '"'

|| O.OBJECT_NAME

|| '"'

|| ' TO appsro;' COMMAND

FROM ALL_OBJECTS O

WHERE O.OBJECT_TYPE IN ('TABLE','PACKAGE','PACKAGE BODY','PROCEDURE', 'VIEW','FUNCTION')

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center