| |
General
Page history last edited by Eddie Awad 2 yrs ago
Best Practices:
- Tables in the SYS schema are manipulated only by the database. They should never be modified by any user or database administrator, and no one should create any tables in the schema of user SYS. Database users should not connect to the Oracle database using the SYS account.
- Never use the SYSTEM schema to store tables of interest to non-administrative users.
Worst Practices:
- Ten things Oracle developers should never do
- Run non-select commands in production without testing first.
- Change the definition of a standard database object.
- Leave open update commands in code editors.
- Execute scripts in production by yourself.
- Forget how to deal with commands that take a long time to execute.
- Forget to protect passwords.
- Leave your desk when you have a connection open on production.
- Give out customer data.
- Forget to maintain version control.
- Develop Prod-sensitive connections to third party interfaces.
- Ten worst practices when using Oracle JDBC Drivers
General
|
|
Tip: To turn text into a link, highlight the text, then click on a page or file from the list above.
|
|
|
Comments (0)
You don't have permission to comment on this page.