What is privilege and why is it required? Explain the different system and object privileges used in ORACLE database with their importance. Write command to do following: a) Create common user and…

What is privilege and why is it required? Explain the different system and object privileges used in ORACLE database with their importance. Write command to do following: a) Create common user and local user. b) Create a role, assign two system privileges on role and assign role to user. c) Allocate unlimited space to user on 'users' tablespace d) Create profile with following parameter. i) Failed_login_attempts 2 ii) Idle time 5 iii) Sessions per user 3 e) Assign profile to the user.