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;
|