top button
Flag Notify
    Connect to us
      Facebook Login
      Site Registration Why to Join

Facebook Login
Site Registration

What are the System and Object Privileges?

+2 votes
29 views
What are the System and Object Privileges?
posted Jul 31, 2015 by Kunal Kapoor

Share this question
Facebook Share Button Twitter Share Button Google+ Share Button LinkedIn Share Button Multiple Social Share Button

1 Answer

0 votes

System privileges

System privileges are privileges given to users to allow them to perform certain functions that deal with managing the database and the server . Most of the different types of permissions supported by the database vendors fall under the system privilege category. Let’s go through some examples of system privileges in Oracle and SQL Server.

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.

Object privileges

Object privileges are privileges given to users so that they can perform certain actions upon certain database objects – where database objects are things like tables, stored procedures, indexes, etc. Some examples of object privileges include granting a particular database user the right to DELETE and/or SELECT from a particular table. This is done using the GRANT clause, which you can read more about here: SQL GRANT.

answer Aug 3, 2015 by Manikandan J
Contact Us
+91 9880187415
sales@queryhome.net
support@queryhome.net
#280, 3rd floor, 5th Main
6th Sector, HSR Layout
Bangalore-560102
Karnataka INDIA.
QUERY HOME
...