SQL Language Guide : 8. SQL Statements : CREATE PROFILE : CREATE PROFILE Examples
 
Share this page                  
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;