| insufficient privilages in create view [message #396971] |
Wed, 08 April 2009 09:24  |
sundarfaq
Messages: 235
Registered: October 2007
Location: Chennai
|
Senior Member |
|
|
Hi,
there are tow schema such as master schema and slave schema.the employees table is present in slave schema.I have created synonyms in master table for employees table in slave schema and also given insert,update,delete privilages to this objects.
login into master schema:
create synonym employees for slave.employees.
disconnected from master schema.
login into slave schema,
grant select,insert,update,delete to master.employees.
disconnected.
after that login into master schema.
create or replace emp_view
as
select first_name||last_name
from employees;
ORA-01031: insufficient privileges error i am getting.
please give an instructions.
Thanks,
michael.
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
