SQL SERVER QUESTION Use the following database: https://codeshare.io/aJQQZ6 Use

Question

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 tempuser’s user account

Unlock tempuser’s user account

Force tempuser user to change his or her password.

Drop termpuser.

Explanation / Answer

create user developer for login USER_TAB_PRIVS
ALTER LOGIN USER_TAB_PRIVS WITH PASSWORD = developer1

create role DeveloperRole

GRANT SELECT, INSERT, UPDATE, DELETE ON object to developerRole

CREATE LOGIN SYSTEM_PRIVILEGE_MAP WITH PASSWORD = 'webdev';
CREATE USER webdev FOR LOGIN SYSTEM_PRIVILEGE_MAP

CREATE LOGIN USER_TAB_PRIVS WITH PASSWORD = 'DeveloperRole ';
CREATE USER webdev2 FOR LOGIN USER_TAB_PRIVS

drop role DeveloperRole

CREATE ROLE SPOwner

GRANT ALL ON SP TO SPOwner ;

DROP ROLE SPOwner;

create role ADMIN

grant all on sys.name to ADMIN;

drop role ADMIN;

create LOGIN USER_TAB_PRIVS WITH PASSWORD = 'tempuser';
CREATE USER tempuser FOR LOGIN USER_TAB_PRIVS

Related Questions

Navigate

• Browse (All)
• Browse S
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.