Greenplum has Roles and we can support Create Role Visual Editor for Greenplum in future
Synopsis
CREATE ROLE name [[WITH] option [ ... ]]
where option can be:
SUPERUSER | NOSUPERUSER
| CREATEDB | NOCREATEDB
| CREATEROLE | NOCREATEROLE
| CREATEEXTTABLE | NOCREATEEXTTABLE
[ ( attribute='value'[, ...] ) ]
where attributes and values are:
type='readable'|'writable'
protocol='gpfdist'|'http'|'gphdfs'
| INHERIT | NOINHERIT
| LOGIN | NOLOGIN
| CONNECTION LIMIT connlimit
| [ ENCRYPTED | UNENCRYPTED ] PASSWORD 'password'
| VALID UNTIL 'timestamp'
| IN ROLE rolename [, ...]
| ROLE rolename [, ...]
| ADMIN rolename [, ...]
| RESOURCE QUEUE queue_name
Issue #8110 |
Closed |
Duplicate |
Resolved |
Completion |
No due date |
No fixed build |
No time estimate |
1 issue link |
duplicates #7930
Issue #7930Support roles in Greenplum |
We discussed this before, see issue #7930 for details. Both CREATE GROUP and CREATE USER are an alias for CREATE ROLE.