API tools faq
paste
Advertisement
class_connect

Untitled

class_connect
Sep 17th, 2024
60
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PL/SQL 0.93 KB | Source Code | 0 0
raw download clone embed print report
  1. SQL>   CREATE USER JOHN_DOE IDENTIFIED BY User_test1111;
  2.  
  3. USER created.
  4.  
  5. SQL>   GRANT SELECT ON EMPLOYEES TO JOHN_DOE;
  6.  
  7. Grant succeeded.
  8.  
  9. SQL>   GRANT INSERT ON EMPLOYEES TO JOHN_DOE;
  10.  
  11. Grant succeeded.
  12.  
  13. SQL>   GRANT UPDATE ON EMPLOYEES TO JOHN_DOE;
  14.  
  15. Grant succeeded.
  16.  
  17. SQL>   GRANT DELETE ON EMPLOYEES TO JOHN_DOE;
  18.  
  19. Grant succeeded.
  20.  
  21. SQL>   GRANT ALL PRIVILEGES ON EMPLOYEES TO JOHN_DOE;
  22.  
  23. Grant succeeded.
  24.  
  25. SQL>   REVOKE SELECT ON EMPLOYEES FROM JOHN_DOE;
  26.  
  27. Revoke succeeded.
  28.  
  29. SQL>   REVOKE INSERT ON EMPLOYEES FROM JOHN_DOE;
  30.  
  31. Revoke succeeded.
  32.  
  33. SQL>   REVOKE UPDATE ON EMPLOYEES FROM JOHN_DOE;
  34.  
  35. Revoke succeeded.
  36.  
  37. SQL>   REVOKE DELETE ON EMPLOYEES FROM JOHN_DOE;
  38.  
  39. Revoke succeeded.
  40.  
  41. SQL>   REVOKE ALL PRIVILEGES ON EMPLOYEES FROM JOHN_DOE;
  42.  
  43. Revoke succeeded.
  44.  
  45. SQL>   GRANT SELECT,UPDATE ON EMPLOYEES TO JOHN_DOE;
  46.  
  47. Grant succeeded.
  48.  
  49. SQL>   REVOKE SELECT,UPDATE ON EMPLOYEES FROM JOHN_DOE;
  50.  
  51. Revoke succeeded.
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!