Oracle Learning Notes (ii)

2.Oracle User Management
(1) Creating User: Create username identified by password (DBA authority required);
Sql>create user YZW identified by YZW
Default tablespace users//user table space
Temporary tablespace temp//user Temp table space
Quato 3m on users; User YZW established Data Objects (table, cable, view, PL/SQL block ...) The biggest one is 3m.
(2) Assigning permissions to users: Grant create permission to user;
Sql>grant create session to YZW; Assign this permission user to log in
(3) Assigning roles to users: Grant role to user;
Sql>grant Connect to YZW;
(4) The administrator user reclaims the role revoke permissions from the user;
Sql>revole Connect from YZW;
(5) Delete users: Drop user username;
Sql>drop user yzw Cascade;cascade means to delete the users and delete the data objects established by the user

PS: This article for Bo Master original, reprint please indicate source: http://www.cnblogs.com/Y-zhiwei/.

Oracle Learning Notes (ii)