PrepAway - Latest Free Exam Questions & Answers

Which CREATE statement will accomplish this?

You are asked to create a new database called PRODDB where no privileges will be automatically
granted to PUBLIC
Which CREATE statement will accomplish this?

PrepAway - Latest Free Exam Questions & Answers

A.
CREATE DATABASE proddb GRANT PUBLIC NO

B.
CREATE DATABASE proddb SECURE

C.
CREATE DATABASE proddb REVOKE ALL FROM PUBLIC

D.
CREATE DATABASE proddb RESTRICTIVE


Leave a Reply