Database Administration (MOSC)

MOSC Banner

How to Create New Database User To access some APPS viewes

edited Jul 7, 2015 10:06AM in Database Administration (MOSC) 5 commentsAnswered

Dear All,


For business purposes, we need to create new database user. This user needs to read some APPS  views, so we granted all on application context fnd_global.APPS_INITIALIZE to that user;


grant all on fnd_global to xxuser;


but when logging to the xxuse and run:


begin fnd_global.APPS_INITIALIZE(0,0,0); end;


it generate error:

ERROR at line 2:

ORA-06550: line 2, column 1:

PLS-00201: identifier 'FND_GLOBAL.APPS_INITIALIZE' must be declared

ORA-06550: line 2, column 1:

PL/SQL: Statement ignored



Thanks in advance;

Shareef




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