Question: a) Use SQL command line to create a new user. Enable the created user to connect to the database and perform most of administrative functions.

a) Use SQL command line to create a new user. Enable the created user to connect to the database and perform most of administrative functions.

(b) Create a profile and assign the profile to the created user. Implement a security policy for the account.

(c) Unlock the created user account after it is locked because of repeated failed login attempts.

(d) As system user, create a new role and grant privileges “drop any table” to this role and then assign the role to the created user.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Computer Network Questions!