Oracle User Creation and Management
1) As a competent DBA, before creating a new user to check the following items: * Determine the object must be stored in the user table space; * Determine the quota for each table space; * Give the user the default table space and temporary table space; * Create a user; * The user system privileges and roles required to give users; 2) The following example creates a user: create user infotech - -to create a user name for the infotech; identified by infotech -- the user's password is infotech; default tablespace APEX_SPACE -- the user's default table space is APEX_SPACE; temporary tablespace temp --the user temporary table space is pioneer_temp; quota 30m on APEX_SPACE --the user to use up to 30M in APEX_SPACE space; quota 30m on users --the user in the users table space to use up to 30M of space; password expire --the first time the user logs in, password invalid, the system prompted to enter a new password; account unlock --User
