Vector 6.2 | 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: 06/28/2024