Database

Oracle Net Services

Published by : Obay Salah , November 19, 2024

 To have a server (Database Server) that contains the database to which all Client Applications or all devices that contain programs that need to... Continue Reading

Data Guard

Getting Ready To Create Standby Database From Primary Database

Published by : Obay Salah , November 19, 2024

 Before creating the Standby Database, the following steps must be done in the Primary Database:1- Activate Forced Logging:ALTER DATABASE FORCE L... Continue Reading

Database

Oracle Database Auditing

Published by : Obay Salah , November 19, 2024

 Database monitoring is part of database security and through the monitoring process we can find many answers to some matters that would remain a... Continue Reading

Database

Oracle Database Security

Published by : Obay Salah , November 19, 2024

 There are many steps that a database administrator can take to secure the database, I will mention some of them:1- Protecting the DATA DICTIONAR... Continue Reading

Database

Oracle Database Profile

Published by : Obay Salah , November 19, 2024

 It is for managing the password as well as the resources, after how long will the password be terminated? What is the number of failed attempts... Continue Reading

Database

Oracle Database Role

Published by : Obay Salah , November 19, 2024

 Imagine with me that you are working as a database administrator with more than 1000 users, these users are at different levels of permissions,... Continue Reading

Database

Oracle Users Privileges

Published by : Obay Salah , November 19, 2024

 All the users we created in the previous scenarios cannot connect to the database let alone perform any other tasks as they do not have permissi... Continue Reading

Database

Oracle Authentication Type

Published by : Obay Salah , November 19, 2024

 It is the method of verifying users to access the database. At the moment of creating the user, the verification method must be chosen: -Passwor... Continue Reading

Database

Tablespace Quota

Published by : Obay Salah , November 19, 2024

 It is the share available to the user to create objects in the Tablespaces and without it the user is unable to create any object.Therefore, the... Continue Reading

Database

Create and Manage Oracle Users

Published by : Obay Salah , November 19, 2024

 The basic idea is that access to the database requires the presence of a user who has access authority, otherwise the database cannot remain ava... Continue Reading