The REVOKE statement removes database privileges.
The CREATE SCHEMA statement.
The login account grants access to the SQL Server instance to log in and access resources. The database user account is what gains access to the database and is assigned rights.
All users of the database are granted the privileges.
The SELECT privilege.
An object-level privilege.
The CASCADE option is used with the REVOKE statement to remove other users’ access that was granted by the affected user.
No. You can use only the DELETE, INSERT, and UPDATE commands on views you create from a single table.
Yes. The owner of a view is automatically granted the appropriate privileges on the view.