Home » RDBMS Server » Security » Oracle 19c Security O7 dictionary parameter de supported (Oracle 19c )
Oracle 19c Security O7 dictionary parameter de supported [message #677962] Sat, 26 October 2019 01:13 Go to next message
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.
Re: Oracle 19c Security O7 dictionary parameter de supported [message #677966 is a reply to message #677962] Sat, 26 October 2019 01:54 Go to previous messageGo to next message
John Watson
Messages: 8922
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>
Re: Oracle 19c Security O7 dictionary parameter de supported [message #677970 is a reply to message #677966] Sat, 26 October 2019 03:00 Go to previous messageGo to next message
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$;
Re: Oracle 19c Security O7 dictionary parameter de supported [message #677974 is a reply to message #677970] Sat, 26 October 2019 03:28 Go to previous messageGo to next message
John Watson
Messages: 8922
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.
Re: Oracle 19c Security O7 dictionary parameter de supported [message #677977 is a reply to message #677974] Sat, 26 October 2019 03:54 Go to previous messageGo to next message
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!

Re: Oracle 19c Security O7 dictionary parameter de supported [message #677978 is a reply to message #677977] Sat, 26 October 2019 06:05 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
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.

Re: Oracle 19c Security O7 dictionary parameter de supported [message #679457 is a reply to message #677978] Tue, 03 March 2020 01:14 Go to previous message
4waytechnologies
Messages: 1
Registered: March 2020
Junior Member
Thanks sir
Previous Topic: SYS/SYSDBA is special
Next Topic: Store and retrieve a key from db wallet
Goto Forum:
  


Current Time: Thu Mar 28 09:35:13 CDT 2024