OraFAQ Forum: Security » Oracle 19c Security O7 dictionary parameter de supported

Home » RDBMS Server » Security » Oracle 19c Security O7 dictionary parameter de supported (Oracle 19c )

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Oracle 19c Security O7 dictionary parameter de supported [message #677962]

Sat, 26 October 2019 01:13

SivaK
Messages: 3
Registered: October 2019

Junior Member

Starting from Oracle 19c , the parameter O7 Dictionary has been de supported. Hence other users unable to create view on SYS.CDEF$

Please suggest.

Report message to a moderator

Re: Oracle 19c Security O7 dictionary parameter de supported [message #677966 is a reply to message #677962]

Sat, 26 October 2019 01:54

John Watson
Messages: 8163
Registered: January 2010
Location: Global Village

Senior Member

Welcome to the forum. Please read the OraFAQ Forum Guide and How to use code tags and make your code easier to read

orclz>
orclz> connect / as sysdba
Connected.
orclz> grant select on cdef$ to scott with grant option;

Grant succeeded.

orclz> conn scott/tiger
Connected.
orclz> create view v1 as select * from sys.cdef$;

View created.

orclz>

Report message to a moderator

Re: Oracle 19c Security O7 dictionary parameter de supported [message #677970 is a reply to message #677966]

Sat, 26 October 2019 03:00

SivaK
Messages: 3
Registered: October 2019

Junior Member

Thank you for response.

In case, we want to create same view in sys schema with scott user, any other privileges required.
create view sys.v1 as select * from sys.cdef$;

Report message to a moderator

Re: Oracle 19c Security O7 dictionary parameter de supported [message #677974 is a reply to message #677970]

Sat, 26 October 2019 03:28

John Watson
Messages: 8163
Registered: January 2010
Location: Global Village

Senior Member

Creating a view in SYS is such a bizarre requirement that I cannot see how anyone can advise without more information about what you are trying to achieve.

Report message to a moderator

Re: Oracle 19c Security O7 dictionary parameter de supported [message #677977 is a reply to message #677974]

Sat, 26 October 2019 03:54

SivaK
Messages: 3
Registered: October 2019

Junior Member

Hi ... I understand it. Thank you!

We have age old code which is creating view in SYS schema from SYS table. This was working till previous release by setting parameter ' O7 Dictionary ' set to TRUE.

As parameter 'O7 DICTIONARY' has been de-supported in Oracle 19c, this piece of code is causing "ORA-01031' error.

I would recommend my technical team to create view without "SYS." .

Thank you once again!

Report message to a moderator

Re: Oracle 19c Security O7 dictionary parameter de supported [message #677978 is a reply to message #677977]

Sat, 26 October 2019 06:05

Michel Cadot
Messages: 66861
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Creating stuff in SYS schema invalidates your Oracle support and leads to unsupported installation.
The ONLY thing you can create in SYS schema is the password verify function.

Report message to a moderator

Previous Topic:	SYS/SYSDBA is special
Next Topic:	Encryption

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Feb 23 03:10:01 CST 2020