Question: 1 . Create a new user: the username is your abc and choose a password for it . 2 . Grant the privilege create _

1. Create a new user: the username is your abc and choose a password for it.
2. Grant the privilege create_session to the user abc
3. Conn to abc, and try to apply a select statement on doctors (describe what
happens)
4. Conn to system, and grant user abc limited privileges (SELECT) on table
doctors
5. Conn to abc, and apply a valid select statement on doctors.

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 Databases Questions!