Database Administration (MOSC)

MOSC Banner

create view not running

edited Dec 17, 2012 8:04AM in Database Administration (MOSC) 5 commentsAnswered
I have created user with create view privilege and other privilege such as

grant select on INV.MTL_PARAMETERS to xxcasco;
grant select on WIP.WIP_ENTITIES to xxcasco;
grant select on APPS.MTL_SYSTEM_ITEMS_B to xxcasco;
grant select on WIP.WIP_DISCRETE_JOBS to xxcasco;
grant select on WIP.WIP_OPERATIONS to xxcasco;

create synonym xxcasco.MTL_PARAMETERS for INV.MTL_PARAMETERS;
create synonym xxcasco.WIP_ENTITIES for WIP.WIP_ENTITIES;
create synonym xxcasco.MTL_SYSTEM_ITEMS for APPS.MTL_SYSTEM_ITEMS_B;
create synonym xxcasco.WIP_DISCRETE_JOBS for WIP.WIP_DISCRETE_JOBS;
create synonym xxcasco.WIP_OPERATIONS for WIP.WIP_OPERATIONS;

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