Explanation:The role is first created and the authorization is given on relation takes to the role. 6. Which of the following is true regarding views ?
A. The user who creates a view cannot be given update authorization on a view without having update authorization on the relations used to define the view.
B. The user who creates a view cannot be given update authorization on a view without having update authorization on the relations used to define the view.
C. If a user creates a view on which no authorization can be granted, the system will allow the view creation request.
D. A user who creates a view receives all privileges on that view.
Answer:A
Explanation:The role is first created and the authorization is given on relation takes to the role. 6. Which of the following is true regarding views ?
A. The user who creates a view cannot be given update authorization on a view without having update authorization on the relations used to define the view. B. The user who creates a view cannot be given update authorization on a view without having update authorization on the relations used to define the view. C. If a user creates a view on which no authorization can be granted, the system will allow the view creation request. D. A user who creates a view receives all privileges on that view.
Explanation:A user who creates a view does not necessarily receive all privileges on that view. 7. If we wish to grant a privilege and to allow the recipient to pass the privilege on to other users, we append the __________ clause to the appropriate grant command.