SQL SERVER QUESTION

Use the following database: https://codeshare.io/aJQQZ6

Use USER_TAB_PRIVS and SYSTEM_PRIVILEGE_MAP to display every step you created;

Create user name developer with password developer

Change the password for the developer user to developer1

Create Role Name DeveloperRole

Grant SELECT, INSERT,UPDATE, DELETE privilege to DeveloperRole

Create user name webdev with the password webdev

Create user name appdev with the password appdev

Grant permission webdev, appdev to DeveloperRole

Remove webdev from DeveloperRole permission

Remove webdev2 from DeveloperRole permission

Drop DeveloperRole role

Create Role Name SPOwner

Grant SPOwner full permission of SP database

Drop SPOwner role

Create Role Name Admin

Grant Admin Role full permission of the system wide

Drop Admin Role.

Create user name tempuser with password tempuser

Lock tempusers user account

Unlock tempusers user account

Force tempuser user to change his or her password.

Drop termpuser.