Actian Ingres 12.1 | CREATE PROFILE Examples

Was this helpful?

CREATE PROFILE Examples

1. Specify a profile for a particular user.

CREATE PROFILE dbop;

CREATE USER bspring WITH PROFILE = dbop;

2. Create a dbop profile with the appropriate privileges to maintain a database.

CREATE PROFILE dbop WITH

PRIVILEGES = (OPERATOR, MAINTAIN_LOCATIONS, TRACE),

GROUP = dbopgroup;

Last modified date: 01/27/2026