-
error when creating view
Hi,
I can select from tables
SQL> select count(*)
2 FROM (
3 SELECT DISTINCT (c.contract_id),p.party_id,name
4 FROM LDMV_CONTRACT_FIN_DTL f
5 ,axiom.contract c, axiom.party p
6 where c.cparty_id = p.party_id
7 and c.contract_id = f.contract_id
8 ORDER BY contract_id
9 )
10 /
COUNT(*)
----------
7401
but have this error when creating view
SQL> ed
Wrote file afiedt.buf
1 create view ldv_cpty_fin
2 as
3 select count(*)
4 FROM (
5 SELECT DISTINCT (c.contract_id),p.party_id,name
6 FROM LDMV_CONTRACT_FIN_DTL f
7 ,axiom.contract c, axiom.party p
8 where c.cparty_id = p.party_id
9 and c.contract_id = f.contract_id
10 ORDER BY contract_id
11* )
SQL> /
,axiom.contract c, axiom.party p
*
ERROR at line 7:
ORA-01031: insufficient privileges
Does any one have any idea why this is so
Thks
-
We have resolve this problem.
Privilege must be granted directly to User not role (oracle BUG )
-
not a bug, intended functionality and has been that way for years
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|