File: alter_user.sql

package info (click to toggle)
sqlfluff 3.5.0-2
  • links: PTS, VCS
  • area: main
  • in suites: forky, sid
  • size: 34,000 kB
  • sloc: python: 106,131; sql: 34,188; makefile: 52; sh: 8
file content (59 lines) | stat: -rw-r--r-- 1,707 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
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
alter user admin createdb;
alter user admin with createdb;

alter user admin nocreatedb;
alter user admin with nocreatedb;

alter user "dbuser" reset var;
alter user "dbuser" with reset var;

alter user admin createuser;
alter user admin with createuser;

alter user admin nocreateuser;
alter user admin with nocreateuser;

alter user admin syslog access restricted;
alter user admin with syslog access restricted;

alter user admin syslog access unrestricted;
alter user admin with syslog access unrestricted;

alter user iam_superuser password 'mdA51234567890123456780123456789012';
alter user iam_superuser with password 'mdA51234567890123456780123456789012';

alter user iam_superuser password DISABLE;
alter user iam_superuser with password DISABLE;

alter user admin password 'adminPass9' valid until '2017-12-31 23:59';
alter user admin with password 'adminPass9' valid until '2017-12-31 23:59';

alter user admin rename to sysadmin;
alter user admin with rename to sysadmin;

alter user admin connection limit 10;
alter user admin with connection limit 10;

alter user admin connection limit unlimited;
alter user admin with connection limit unlimited;

alter user dbuser session timeout 300;
alter user dbuser with session timeout 300;

alter user dbuser reset session timeout;
alter user dbuser with reset session timeout;

alter user dbuser set var to 100;
alter user dbuser with set var to 100;

alter user dbuser set var = 'hi';
alter user dbuser with set var = 'hi';

alter user dbuser set var to default;
alter user dbuser with set var to default;

alter user dbuser set var = default;
alter user dbuser with set var = default;

alter user dbuser reset var;
alter user dbuser with reset var;