Question

What are the System and Object Privileges?

Answer 1

Examples of Oracle system privileges

CREATE USER. The CREATE USER permission, when granted to a database user, allows that database user to create new users in the database.

CREATE TABLE. The CREATE TABLE permission, when granted to a database user, allows that database user to create tables in their own schema. This type of privilege is also available for other object types – like stored procedures and indexes.

CREATE SESSION. The CREATE SESSION permission, when granted to a database user, allows that database user to connect to the database.

Examples of Microsoft SQL Server System Privileges

BACKUP DATABASE. The BACKUP DATABASE permission, when granted to a database user, allows that database user to create backups of the databases on the server.

CREATE DATABASE. The CREATE DATABASE permission, when granted to a database user, allows that database user to create new databases on the server.

SHUTDOWN. The SHUTDOWN permission, when granted to a database user, allows that database user to issue a command to shutdown the server.