Geek asks and answers

A good role for Oracle for the personal use of the developer?

We install some Oracle XE servers (free) on user desktops for development.

What is a good default role for these developers? Since these instances contain only data from scratch, data security is not a concern.

+3
source share
2 answers

If you want developers to be able to do something, provide a DBA in the development database. Of course, there is a risk with this; if they develop and run the code on their own, they will not solve the security requirements of the application.

If you want developers to work with the application security context, provide them with the same roles as the application in Prod.

, , - Dev, , Prod, 2 . -, , Prod, - DBA DBA.

, Windows ( , - .. ), Unix, , SUDO.

+1

, dev, SYSTEM, . - , , , .

+1

More articles:


All Articles