CREATE USER

Create a user.

Syntax:

   CREATE USER username
      IDENTIFIED {BY password | EXTERNALLY | GLOBALLY AS external_name}
         options

options:
   
   DEFAULT TABLESPACE tablespace_name
   TEMPORARY TABLESPACE tablespace_name
   QUOTA int {K | M} ON tablespace_name
   QUOTA UNLIMITED ON tablespace_name
   PROFILE profile_name
   PASSWORD EXPIRE
   ACCOUNT {LOCK|UNLOCK}

You have to create a user first before you can GRANT permissions, roles or assign a default ROLE.

"If you bungle raising your children, I don't think whatever else you do well matters very much" - Jacqueline Kennedy Onassis

Related Commands:

ALTER USER DEFAULT ROLE
DROP USER

Related Views:

                                           USER_PASSWORD_LIMITS  
                                                                SESSION_ROLES
                                                                SESSION_PRIVS
                                                                SESSION_CONTEXT
 DBA_TS_QUOTAS                             USER_TS_QUOTAS
 DBA_USERS            ALL_USERS            USER_USERS

 V$SESSION
 V$SESSION_CONNECT_INFO
  




Back to the Top

Simon Sheppard
SS64.com