This category of authorities allows a user to perform activities specific to a database. These activities are viewing/modifying data in the database, granting and revoking privileges to users, performing data load operations, running maintenance activities like collecting statistics, backups and restores, and so on.
We need
SYSADM
authority to grantDBADM
orSECADM
authorityWe need
SYSADM
orDBADM
authority to grant other database authorities
Let's see how we can grant and revoke database-level authorities. The process is the same for every type of database-level authority.
GRANT <authority_name> ON DATABASE <db_name> to USER/ROLE/GROUP <name>
For...