Skip to main content
Home
  • Tutorials
    • Quality Assurance
    • Software Development
    • Machine Learning
    • Data Science
  • About Us
  • Contact
programsbuzz facebook programsbuzz twitter programsbuzz linkedin
  • Log in

Main navigation

  • Tutorials
    • Quality Assurance
    • Software Development
    • Machine Learning
    • Data Science
  • About Us
  • Contact

Oracle: REVOKE statement

Profile picture for user akshita.goel
Written by akshita.goel on 01/11/2022 - 12:04

REVOKE Statement in Oracle is used to revoke privileges for existing users. In easy terms, we can say that this statement is used to fetch some rights from the users in the database. 

To check all the session privileges, you can use the following code:

select * from session_privs;

For instance, You have a user as NEW_USER, and you what to check all the privileges of that user.

privileges

some of the Privileges we can REVOKE from users is shown below:

  1. Create Session
  2. Alter Session
  3. Create Table
  4. Alter Table
  5. Delete Table
  6. Create Views
  7. Create Sequence
  8. Create Synonyms

Along with the above-mentioned privileges, there are many more.

Syntax

REVOKE PRIVILEGE_TYPE from USER_NAME;

Example

Let's try to create a table from user NEW_USER:

create table Stu(Name Varchar(20));

create Stu

You found the User named NEW_USER is using a lot more memory space for creating Tables. So, you want to revoke a particular user for creating new tables. 

NOTE: To do so, we will revoke CREATE TABLE and CREATE ANY TABLE privileges from the user.

REVOKE CREATE TABLE from NEW_USER;
REVOKE CREATE ANY TABLE from NEW_USER;

Output

Now, If you try to create a table using NEW_USER, It will display the following output:

REVOKE STATEMENT

Related Content
Oracle Tutorial
Oracle: COMMIT statement
Oracle: ROLLBACK Statement
  • Log in or register to post comments

Choose Your Technology

  1. Agile
  2. Apache Groovy
  3. Apache Hadoop
  4. Apache HBase
  5. Apache Spark
  6. Appium
  7. AutoIt
  8. AWS
  9. Behat
  10. Cucumber Java
  11. Cypress
  12. DBMS
  13. Drupal
  14. GitHub
  15. GitLab
  16. GoLang
  17. Gradle
  18. HTML
  19. ISTQB Foundation
  20. Java
  21. JavaScript
  22. JMeter
  23. JUnit
  24. Karate
  25. Kotlin
  26. LoadRunner
  27. matplotlib
  28. MongoDB
  29. MS SQL Server
  30. MySQL
  31. Nightwatch JS
  32. PactumJS
  33. PHP
  34. Playwright
  35. Playwright Java
  36. Playwright Python
  37. Postman
  38. Project Management
  39. Protractor
  40. PyDev
  41. Python
  42. Python NumPy
  43. Python Pandas
  44. Python Seaborn
  45. R Language
  46. REST Assured
  47. Ruby
  48. Selenide
© Copyright By iVagus Services Pvt. Ltd. 2023. All Rights Reserved.

Footer

  • Cookie Policy
  • Privacy Policy
  • Terms of Use