Home » SQL & PL/SQL » SQL & PL/SQL » insufficient privilages in create view (Oracle,10g,Linux)
insufficient privilages in create view [message #396971] Wed, 08 April 2009 09:24 Go to next message
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.

Re: insufficient privilages in create view [message #396975 is a reply to message #396971] Wed, 08 April 2009 09:28 Go to previous messageGo to next message
BlackSwan
Messages: 25036
Registered: January 2009
Location: SoCal
Senior Member
>please give an instructions.
issue needed GRANTs

You need to help us by following the Posting Guidelines as stated below.
http://www.orafaq.com/forum/t/88153/0/
Please, please, please Read & Follow Posting Guidelines above.
Go to the section labeled "Practice" & do as directed.


Re: insufficient privilages in create view [message #396977 is a reply to message #396971] Wed, 08 April 2009 09:32 Go to previous messageGo to next message
user2004
Messages: 33
Registered: April 2009
Member
To create view in your own schema you need to have CREATE VIEW priviledge while to create a view in other schema you need to have CREATE ANY VIEW priviledge.


Regards
Re: insufficient privilages in create view [message #396990 is a reply to message #396971] Wed, 08 April 2009 10:12 Go to previous message
Michel Cadot
Messages: 64107
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Read the prerequisites concerning CREATE VIEW in the documentation.
Do you satisfy them?

Regards
Michel
Previous Topic: Maximum Value Wihtout using Oracle Functions
Next Topic: refresh a materialized view
Goto Forum:
  


Current Time: Mon Dec 05 04:41:49 CST 2016

Total time taken to generate the page: 0.05889 seconds