Ledger Nano X - The secure hardware wallet
SHARE
TWEET

Untitled

Artur123ff2 Apr 8th, 2020 159 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. 6a
  2.  
  3. CREATE USER 'user1'@’localhost’ IDENTIFIED BY 'user1';
  4. GRANT SELECT ON "university"."employees" TO "user1"@"localhost";
  5.  
  6. 6b
  7.  
  8. --nic--
  9.  
  10. 6c
  11.  
  12. DROP TABLE employees
  13.  
  14. 6d
  15.  
  16. select * from subjects
  17.  
  18. 6e
  19.  
  20. GRANT DELETE ON "university"."teams" TO "user1"@"localhost";
  21.  
  22. 6f
  23.  
  24. --nic--
  25.  
  26. 6g
  27.  
  28. delete from teams where team_id = '1';
  29.  
  30. 6h
  31.  
  32. GRANT SELECT ON "university"."teams" TO "user1"@"localhost";
  33.  
  34. 6i
  35.  
  36. delete from teams where team_id = '1';
  37.  
  38.  
  39. 6j
  40.  
  41. CREATE VIEW `databases` AS SELECT employee_id, emp_name from employees;
  42.  
  43. 6k
  44.  
  45. GRANT SELECT ON "databases" TO "user1"@"localhost";
  46.  
  47. 6l
  48.  
  49. SELECT `employee_id`, `emp_name` FROM `university`.`databases`
  50.  
  51. 6m
  52.  
  53. select * from employees
  54.  
  55. ----------------------------------------------------------------------------------
  56. ----------------------------------------------------------------------------------
  57.  
  58. 6n
  59.  
  60. UPDATE `databases` SET `emp_name`=’test’
  61. WHERE `employee_id`=1 AND `emp_name`='MUSHROOM' LIMIT 1;
  62.  
  63.  
  64. 6o
  65.  
  66. GRANT update ON "databases" TO "user1"@"localhost";
  67.  
  68. 6p
  69.  
  70. UPDATE `databases` SET `emp_name`='test'
  71. WHERE `employee_id`=1 AND `emp_name`='MUSHROOM' LIMIT 1;
  72.  
  73. 6q
  74.  
  75. UPDATE `databases` SET `emp_name`='test2' WHERE `employee_id`=1 LIMIT 1;
  76.  
  77.  
  78. -----------------------------------------------------------------------------
  79. -----------------------------------------------------------------------------
  80. -----------------------------------------------------------------------------
  81.  
  82.  
  83. 6r
  84.  
  85. CREATE VIEW `databases1` AS SELECT emp_name from employees;
  86.  
  87. 6s
  88.  
  89. UPDATE `databases1` SET `emp_name`='test3' WHERE `emp_name`='test2' LIMIT 1;
  90.  
  91. 6t
  92.  
  93. GRANT select, update ON "databases1" TO "user1"@"localhost";
  94.  
  95. 6u
  96.  
  97. UPDATE `databases1` SET `emp_name`='test4' WHERE `emp_name`='test3' LIMIT 1;
  98.  
  99. 6v
  100.  
  101. CREATE USER 'sec1'@’localhost’;
  102.  
  103. -----------------------------------------------------------------------------
  104. -----------------------------------------------------------------------------
  105. -----------------------------------------------------------------------------
  106. -----------------------------------------------------------------------------
  107. -----------------------------------------------------------------------------
  108. -----------------------------------------------------------------------------
  109.  
  110. 6w
  111.  
  112.  GRANT SELECT ON "university"."subjects" TO "sec1"@"localhost";
  113.  
  114. 6x
  115.  
  116.  select * from subjects
  117.  
  118. 6y
  119.  
  120.  GRANT SELECT ON "university"."subjects" TO "user1"@"localhost";
  121.  
  122. 6z
  123.  
  124.  GRANT SELECT ON "university"."subjects" TO "user1"@"localhost";
  125.  
  126.  
  127. 6aa
  128.  
  129.  
  130.  
  131. 6bb
RAW Paste Data
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
Top