I have an assignment that is asking me to Write a query that generates the CREATE USER commands for all the managers, writers, and editors, The Create user command must include the appropriate profile. All the users have a password of TEMPPASS and the password expires when the user is created Each employee needs a user name and password for the database. The employee's name is the first name plus the first three letters of the last name. I created three profiles .. Managers, Writers, and Editors. What i don't understand is that is is saying to write a query that generate the Create USER command. I know how to create a user...ie Create User <username> identified by <???>... but this is suggesting to do it in a query.. I'm not quite sure how that is done. Can anyone help me with this please.. Thanks..