Differences between system privilege and object privilege in oracle

Question

1.17K views06/05/2022Oracle Database

0

Ezana886 29/01/2022 0 Comments

Differences between system privilege and object privilege in oracle database?

meda Changed status to publish 06/05/2022

Write your answer.

score 0 · Answer 1 · 2022-01-29T12:41:41+00:00

In oracle there are two types of user privileges:

Object Privilege: Is a permission granted to an Oracle database user account or role to perform some action on a database object ( table, view, function, procedure, package ..).
System Privilege: A privilege that enables users to perform particular actions in the database ( CREATE, ALTER, or DROP the database objects).