Q ) What is Oracle Advanced Collections ? Ans) Oracle Advanced collections is the module which deals primarily with collection of your accounts receivable from the customers. Companies sell to customers on credit and these invoices become due as per the invoice terms. Typically you may specify Net45, which means 100% of the invoice amount […]
When your databases has lots of tables, object privileges can become unwieldy and hard to manage. You can simplify the management of privileges with the use of a database object called a role. A role acts in two capacities in the database. First, the role can act as a focal point for grouping the privileges […]
Privileges are the right to execute particular SQL statements. Two types of privileges exist in Oracle: object privileges and system privileges. Object privileges regulate access to database objects in Oracle, such as querying or changing data in tables and views, creating foreign key constraints and indexes on tables, executing PL/SQL programs, and a handful of […]
In this chapter, you will learn about and demonstrate knowledge in the following areas of user access and privileges in the Oracle database: Creating users Granting and revoking object privileges Using roles to manage database access The basic Oracle database security model consists of two parts. The first part consists of password authentication for all […]
A database link is a schema object in one database that enables you to access objects on another database. The other database need not be an Oracle Database system. However, to access non-Oracle systems you must use Oracle Heterogeneous Services.You might want to create a database link, for instance, if you want the data in […]
Recent Comments