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