Users⚓︎

List existing users⚓︎

select name, state from sys_users ;

Create a user⚓︎

create user <user_name> ;

Create a user with attributes⚓︎

create user <user_name>
with state = ACTIVE|INACTIVE, real_name = 'User Real Name',
description = 'Description for user' ;

Note: By default user are created with an active state. A state 'INACTIVE' means that the user cannot login.

Alter a user⚓︎

alter user <user_name>
set state = ACTIVE|INACTIVE, real_name = 'User Real Name',
description = 'Description for user' ;

Alter user authentication access⚓︎

See authentication page.

Drop a new user⚓︎

drop user <user_name> ;