RE: occurs ORA-01031 when create view with DBA privilege
- From: "Powell, Mark" <mark.powell2@xxxxxx>
- To: oracle-l <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 7 Oct 2013 17:02:33 +0000
If the view references objects owned by other users then I expect that the
other owners need to issue 'grant required_privilege on object with grant
option to view_owner;' .
You should never grant DBA to user's who do not require the role.
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of LuoLee.me
Sent: Monday, October 07, 2013 11:24 AM
To: oracle-l
Subject: occurs ORA-01031 when create view with DBA privilege
Dear lists,
I migrate a database using expdp/impdp and exp/imp today.
When I export a database using expdp, there isn't any errors.
But there are some views, procedure and others error, so I compile it manually.
When I re-compile some view, it says ORA-01031, but I have grant dba to the
specail user. When I see the errors, I try to re-compile it again and again.
I grant select on the the special table to the very user, it didn't take. If I
just select the special view on the fly other than create it, it will list ok.
I didn't understand why it occur ORA-01031 here ?
Thanks all in advance!
All the best,
LuoLee
Mobile: +86 15651803071
See me: http://luolee.me [http://luolee.me]
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
