11-Managing Privileges

11-Managing Privileges - Managing Privileges Presenter...

Info icon This preview shows pages 1–13. Sign up to view the full content.

View Full Document Right Arrow Icon
Managing Privileges Presenter Tathagata Bhattacharjee
Image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Managing Privileges Tathagata Bhattacharjee Objectives After completing this lesson, you should be able to do the following Identify system and object privileges Grant and revoke privileges Identify auditing capabilities
Image of page 2
Managing Privileges Tathagata Bhattacharjee Privileges A privilege is a right to execute a particular type of SQL statement or to access another user’s objects These include right to: Connect to a database Create a table Select rows from another user’s table Execute another user’s stored procedure
Image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Managing Privileges Tathagata Bhattacharjee Types of Privileges 1. System Privilege: Each system privilege allows a user to perform a particular database operation or class of database operations. E.g., the privilege to create tablespace is a system privilege 2. Object Privilege Each object privilege allows a user to perform a particular action on a specific object, such as a table, view, sequence, procedure, function or package
Image of page 4
Managing Privileges Tathagata Bhattacharjee DBA’s control of privileges Providing a user the right to perform a type of operation Granting and revoking access to perform system functions Granting privileges directly to users or to roles Granting privileges to all users (PUBLIC)
Image of page 5

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Managing Privileges Tathagata Bhattacharjee Privileges can be classified as follows: Privileges enabling system wide operations: e.g. CREATE SESSION, CREATE TABLESPACE Privileges enabling management of objects in a user’s own schema: e.g. CREATE TABLE Privileges enabling management of objects in any schema: e.g. CREATE ANY TABLE
Image of page 6
Managing Privileges Tathagata Bhattacharjee System Privileges There are over 100 distinct system privileges The ANY keyword in the privilege signifies that users have the privilege in any schema The GRANT command adds a privilege to a user or a group of users The REVOKE command deletes the privileges
Image of page 7

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Managing Privileges Tathagata Bhattacharjee System Privileges: Examples INDEX CREATE ANY INDEX ALTER ANY INDEX DROP ANY INDEX
Image of page 8
Managing Privileges Tathagata Bhattacharjee TABLE CREATE TABLE CREATE ANY TABLE ALTER ANY TABLE DROP ANY TABLE SELECT ANY TABLE UPDATE ANY TABLE DELETE ANY TABLE
Image of page 9

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Managing Privileges Tathagata Bhattacharjee SESSION CREATE SESSION ALTER SESSION RESTRICTED SESSION
Image of page 10
Managing Privileges Tathagata Bhattacharjee TABLESPACE CREATE TABLESPACE ALTER TABLESPACE DROP TABLESPACE UNLIMITED TABLESPACE
Image of page 11

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Managing Privileges Tathagata Bhattacharjee Granting System Privileges GRANT {system_privileges | role} [, {system_privileges | role} ] … TO {user | role | PUBLIC} [, {user | role | PUBLIC} ] … [WITH ADMIN OPTION] Where, System_privileges specifies the system privileges to be granted Role specifies the role to be granted PUBLIC grants privileges to all users WITH ADMIN OPTION enables the grantee to further grant the privileges or role to other users or roles
Image of page 12
Image of page 13
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern