1.

List any 5 privileges available in MySQL for the User? List of privileges available in MySQL?

Answer»

Privileges: 

1. Select_priv 

2. Insert_priv 

3. Update_priv 

4. Delete_priv 

5. Create_priv 

6. Alter_priv

Action Performed (If Granted):

1. User can select rows from database tables. 

2. User can insert rows into database tables. 

3. User can update rows of database tables. 

4. User can delete rows of database tables. 

5. User can create new tables in database. 

6. User can make changes to the database structure.


Discussion

No Comment Found

Related InterviewSolutions