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 student profile testp; above profile
granted to user student
Revoke dba from student to get back dba rights from user student
