grant 0.1.0

A tool to search files
Documentation 
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
39
40
41
42
43
44
45
46

roles:
  - name: role_database_level
    level: DATABASE
    grants:
      - CREATE
      - TEMP
    databases:
      - db1
      - db2

  - name: role_schema_level
    level: SCHEMA
    grants:
      - CREATE
    databases:
      - db1
      - db2
    schemas:
      - common
      - dwh1
      - dwh2

  - name: role_all_schema
    level: TABLE
    grants:
      - SELECT
      - INSERT
      - UPDATE
    databases:
      - db1
    schemas:
      - common
    tables:
      - ALL

users:
  - name: duyet
    roles:
      - name: role_database_level
      - name: role_all_schema
      - name: role_schema_level
  - name: duyet2
    roles:
      - name: role_database_level
      - name: role_all_schema
      - name: role_schema_level