Chapter 18 Study Questions

Question 1

The _________ statement is used to create a database user that has no Privileges.

Answer 1

create user

Question 2

The __________ a user has to work with a database control the operations that the user can perform on the database.

Answer 2

privileges

Question 3

Use the ______ statement to set up privileges for each users

Answer 3

grants

Question 4

The __________ statement allows one to view the privileges for a user.

Answer 4

show grants

Question 5

Privileges for working with the data in a database are typically given to _________.

Answer 5

all users

Question 6

Privileges for modifying the structure of a database are typically given to _______________________________.

Answer 6

administrators and programmers

Question 7

_________________ allow the user to create and work with database objects such as tables, views and stored procedures.

Answer 7

Object privileges

Question 8

________________ allow the user to create users, grant privileges, and manage operations on the server.

Answer 8

administrative privileges

Question 9

To see a list of available privileges and their definitions use the _______________ statement.

Answer 9

show privileges

Question 10

______ privileges provide a user access to all databases and tables.

Answer 10

Global

Question 11

________ privileges provide a user access to all tables in a specific database.

Answer 11

database

Question 12

_____ privileges provide a user access to all columns in a specific table.

Answer 12

table

Question 13

______ privileges provide a user access only to specific columns in specific tables.

Answer 13

columns

Question 14

Use the ___________ statement to change the name of a user.

Answer 14

rename user