Snippet Name: USERS: CREATE USER w/ authentication
Description: This example shows the CREATE USER syntax to have the user authentication done automatically by the OS on the client PC.
Please note that automatic logins are not secure. The Oracle configuration file can be altered at will by any user. If you allow automatic logins, Oracle recommends that you disable ops$ logins in the listener.ora file.
Language: PL/SQL Highlight Mode: PLSQL Last Modified: March 09th, 2009
CREATEUSER<machine_name\user_name> IDENTIFIED EXTERNALLY;-- in this example, "STELLAR" is the name of the client PC. CREATEUSER"STELLAR\MIKE" IDENTIFIED EXTERNALLY;-- grant the CREATE SESSION privilege to the user
GRANT CREATE SESSION TO"STELLAR\MIKE";-- create a user account on the client PC named "MIKE". -- Login to Windows as "MIKE" and start sqlplus. The -- database should connect automatically without any -- username or password prompts.
SQL University.net courses meet the most demanding needs of the business world for advanced education
in a cost-effective manner. SQL University.net courses are available immediately for IT professionals
and can be taken without disruption of your workplace schedule or processes.
Compared to traditional travel-based training, SQL University.net saves time and valuable corporate
resources, allowing companies to do more with less. That's our mission, and that's what we deliver.