How to Customize AP Invoice Approval in Oracle Fusion cloud Application using Business Process Management(BPM)

                             Data Base Security

Hi Friends

Lets Understand about Oracle Database Security

It provides the security to the Oracle database or schema objects.

It is the concept in oracle which provides high security and accessibility to the database objects

It has been provided interns of different privileges and rights.

Types of Privileges
1 System Privilege
2 Others Privilege

System Privilege :- This is the Privilege provided by the database administrator for system upgrade, patching etc within the database.

Other Privilege:- This the Privilege provided by the database administrator for accessing the objects (table ,view ,synonym ,Index etc) across the database.

Types of Privileges
1> Grant
2> Revoke

1>what is Grant> It is the type of Privilege which is provided by the owner of the objects to be shared across the database.

Syntax of Grants:-

Grant  < Privilege _name> ON <Table name> To USER1,USER2, …;

Example:-
Grant SELECT ON EMP to SCOTT;
Grant ALL ON EMP to SCOTT;
Grant UPDATE,SELECT,INSERT ON EMP to SCOTT;

2> what is Revoke> It is the type of Privilege which is provided by the owner of the objects to be taken back the Privilege given across the database.

Syntax of Revoke:-

Revoke < Privilege _name> ON <Table name> FROM USER1,USER2, …;

Example:-
Revoke SELECT ON EMP FROM SCOTT;

What is Role :- Role is the combinations of privileges and It can be provided all at once to Number of user at a time. It can also be secured by Password.

Syntax of Role:-
Create Role <role_name> identified by <password>;

Example:-

Create Role sale_manager identified by Audit;

Grant ALL ON sale_manager;

Grant sale_manager to U1,U2,…;

Grant insert(EMPNO,ENAME,JOB) ON EMP TO GHAN;

How to Create User in Oracle Database

Create USER <USER_NAME> identified by <Password>

Example :- Create USER GHAN identified by ghan

Hope it helps ...Please like ...