A privilege in a database management system is the permission to execute certain actions on the database.
Privileges can be permitted to:
Privileges make certain actions possible, such as connecting to a database, creating a table, and executing another user’s stored procedure.
Privileges are granted to users so they can accomplish a given task. If privileges are not granted with guidance, this can lead to a security bridge on the database.
There are two main categories of privileges possible in a database:
A system privilege can include the following:
Perform an action on any object of a database.example
Create tablespaces in a database
Delete the rows of any table in a database
We have close to 60 system privileges in existence in the database management system.
System privileges are mostly granted to administrative personnel and application developers. This privilege is usually not open to end-users of the database.
Below is a table of some popular system privileges.
Object privilege is the permission to access specific database objects. Object privilege entails performing a specific action on a particular table, function, or package.
The right to delete rows from a table is an object privilege. Object privileges are granted to normal users, unlike system privileges. Some of the popular object privileges are given below.
Both system and object privileges are very important in a database management system, as they help secure the data stored in a database system.
System privileges are offered to administrators of the database, while object privileges are offered to normal users of the database.