The first example grants Mary and John permission to use create database and create table. Because create database permission is being granted, this command can only be executed by a System Administrator within the master database. Mary and John’s create table permission applies only to the master database.
grant create table, create database to mary, john
This command grants permission to create tables and views in the current database to all users:
grant create table, create view to public
