Toad World® Forums

Oracle SQL statements to create users


#1

Hi guys,

I’m looking to provision an Oracle user from Active Directory, using our ActiveRoles and QuickConnect tools. So far I am unable to do so, I have been given the following select and insert code to create the user: SELECT * FROm ALL_USERS call dbms_utility.exec_ddl_statement(‘CREATE USER’ || :USERNAME || ‘IDENTIFIED BY P@ssword’)SELECT * FROM ALL_USER WHERE USERNAME = :USERNAME I get the following error when I attempt to create the user: ORA-00933: SQL command not properly ended.

Can anyone help with what specifically needs to be set for my query to work properly.

I will also post this on the QuickConnect (Inside ActiveRoles) forum as well.

Thanks
Scott