New database user o select form apps tables and views
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