Vector 6.0 | Create a User

User Guide > User Guide > Creating Databases > How a Database Is Created > Create a User

Was this helpful?

Create a User

To create a user, you must have the required privilege, which is granted by default to the installation owner. You can create a user with the accessdb utility, through SQL by connecting to the iidbdb database, or through Actian Director.

To create a user with SQL

Issue this command at the command line:

sql iidbdb +U -u\$ingres

This directly accesses the system database where commands of the following form can be run to add new users:

CREATE USER myuser WITH NOPROFILE, PRIVILEGES=(CREATEDB,CHANGE_PASSWORD);\go

where myuser is the name of the user to be created.

For details, see the SQL Language Guide.

Last modified date: 11/09/2022