Vector 6.0 | CREATE USER Examples

SQL Language Guide > SQL Language Guide > SQL Statements > CREATE USER > CREATE USER Examples

Was this helpful?

CREATE USER Examples

1. Create a user with several privileges, and a smaller set of default privileges.

CREATE USER bspring
WITH PRIVILEGES=(CREATEDB, SECURITY, TRACE,
DEFAULT_PRIVILEGES = (TRACE);

2. Create a user that requires authentication through the DBMS, rather than through operating system authentication, installation passwords, or Kerberos authentication. Allow the user to change his password:

CREATE USER fred
WITH PASSWORD='secret', PRIVILEGES = (CHANGE_PASSWORD),
DBMS_AUTHENTICATION='REQUIRED';

Last modified date: 11/09/2022