File: gh-4546-sql-drop-grants.result

package info (click to toggle)
tarantool 2.6.0-1
  • links: PTS, VCS
  • area: main
  • in suites: bullseye
  • size: 85,364 kB
  • sloc: ansic: 513,760; cpp: 69,489; sh: 25,650; python: 19,190; perl: 14,973; makefile: 4,173; yacc: 1,329; sql: 1,074; pascal: 620; ruby: 190; awk: 18; lisp: 7
file content (38 lines) | stat: -rw-r--r-- 658 bytes parent folder | download | duplicates (3)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
test_run = require('test_run').new()
---
...
engine = test_run:get_cfg('engine')
---
...
--
-- gh-4546: DROP TABLE must delete all privileges given on that
-- table to any user.
--
box.schema.user.create('test_user1')
---
...
box.schema.user.create('test_user2')
---
...
test_space = box.schema.create_space('T', {		\
	engine = engine,				\
	format = {{'i', 'integer'}}			\
})
---
...
box.schema.user.grant('test_user1', 'read', 'space', 'T')
---
...
box.schema.user.grant('test_user2', 'write', 'space', 'T')
---
...
box.execute([[DROP TABLE T;]])
---
- row_count: 1
...
box.schema.user.drop('test_user1')
---
...
box.schema.user.drop('test_user2')
---
...