Progress
SQL-92
Guide and Reference
CREATE USER Statement
Creates the specified user.
SYNTAX
EXAMPLE
In this example an account with DBA privileges creates the 'username' 'Jasper' with 'password' 'spaniel':
NOTES
- Used in conjunction with ALTER USER Statement and DROP USER Statement, the CREATE USER statement provides a way to manage user records through SQL. This SQL_only solution does not require the Progress dictionary.
- The 'username' and 'password' must be enclosed in quotes.
- Before issuing the CREATE USER statement, there are no users defined in the user table and any user may log into the database.
- After issuing the CREATE USER statement, only users defined in the user table may log into the database.
AUTHORIZATION
Must have DBA privileges
SQL COMPLIANCE
Progress Extension
ENVIRONMENT
Embedded SQL, interactive SQL, ODBC applications, JDBC applications
RELATED STATEMENTS
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |