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 be executed only 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
This example revokes permission to create tables and rules from “mary:”
revoke create table, create rule from mary
