User Privileges
By default, all users have CREATE and USAGE privileges on the PUBLIC schema of a database.
To disallow users from creating objects in the PUBLIC schema of a database, use the REVOKE
command to remove that privilege.
Unless Users are granted the USAGE privilege by the object owner, users cannot access any objects
in schemas they do not own.
Amazon Redshift supports the following privileges: SELECT, INSERT, UPDATE, DELETE, REFERENCES,
CREATE, TEMPORARY, EXECUTE, and USAGE.
The privileges of the object owner, such as DROP, GRANT, and REVOKE privileges, are implicit and cannot be granted
or revoked.
Comments