grant

Gives a privilege.

Syntax

grant PRIVILEGE on TABLE_NAME to USERNAME;
grant all [privileges] on TABLE_NAME to USERNAME;
grant dba to USERNAME;

• The privileges are ALL, ALTER, DELETE, DROP, DUMP, EXECUTE, INSERT, LOCK, SELECT, TRUNCATE and UPDATE.
• You must own the table, or use an administrator account. There is no with grant option.
• grant dba moves the user to the admin group: only an administrator can use it. An administrator can then grant any privilege.
• revoke PRIVILEGE on TABLE_NAME from USERNAME; and revoke dba from USERNAME; take them back.

grant select on gaia_source to claude;