Rbl4m

Following commands were discussed Drop user ahmed         to delete ahmed user Creat user ahmed identified by abc1234 default users temporary tablespace temp quota 100m on users                              to assign 100mb of tablespace to user ahmed Grant creat session session to ahmed Grant creat table to ahmed Grant unlimited tablespace to ahmed Create role enduser Grant create session enduser Grant create table enduser Grant enduser to ahmed Grant dba to ahmed Select * from user_resource_limits; Alter user student identified by abc12334 Alter user student account lock;                      to lock student user Alter user student account unlock;                  to unlock student user Alter user student password expire                 after running this cmd student user can change his own   password himself Select * from user_resourse_limits Create profile testp limit session_per_use 1;                to create a custom profile Alter user

Following commands were discussed Drop user ahmed         to delete ahmed user Creat user ahmed identified by abc1234 default users temporary tablespace temp quota 100m on users                              to assign 100mb of tablespace to user ahmed Grant creat session session to ahmed Grant creat table to ahmed Grant unlimited tablespace to ahmed Create role enduser Grant create session enduser Grant create table enduser Grant enduser to ahmed Grant dba to ahmed Select * from user_resource_limits; Alter user student identified by abc12334 Alter user student account lock;                      to lock student user Alter user student account unlock;                  to unlock student user Alter user student password expire                 after running this cmd student user can change his own   password himself Select * from user_resourse_limits Create profile testp limit session_per_use 1;                to create a custom profile Alter user