What are the System and Object Privileges?
Answers
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.