If the following command is executed:
CREATE DATABASE sample RESTRICTIVE
Which statement is true?
A.
No authorities or privileges will be granted to PUBLIC.
B.
Only the creator is allowed to access the SAMPLE database.
C.
PUBLIC will hold only SELECT privilege on the system catalog views.
D.
The RESTRICT_ACCESS database configuration parameter must be set to YES by the creator.
RESTRICTIVE
If the RESTRICTIVE option is present it causes the restrict_access database configuration parameter to be set to YES and limited privileges and no authorities are automatically granted to PUBLIC. If the RESTRICTIVE option is not present then the restrict_access database configuration parameter is set to NO and privileges are automatically granted to PUBLIC. For information about privileges, see: “Default privileges granted on creating a database”.
0
0