Linker IT Software
Google
Web www.oraxcel.com
menubar-top-links menubar-top-rechts
Home Help Search Login
Welcome, Guest. Please Login.
SQL*XL: Database to Excel bridge litLIB: Excel power functions pack ExcelLock: Locking and securing your valuable Excel spreadsheets encOffice: Protect your Excel file easy and safe encOffice: Protect your Excel file easy and safe
Pages: 1
Insufficient privilege when creating foreign key (Read 2173 times)
Gerrit-Jan Linker
YaBB Administrator
*****




Posts: 75
Insufficient privilege when creating foreign key
16.11.12 at 09:33:05
 
Insufficient privilege when creating foreign key
 
Trying to create a foreign key to a table in another schema I get  
".ORA-01031: insufficient privileges"
 
In the schema to which is referred the references privilege needs to be granted:
grant references on mytable to scott;  
 
Back to top
 
 

Gerrit-Jan Linker
Linker IT Software
Email WWW Gerrit-Jan Linker   IP Logged
Pages: 1