Synonym privileges

Synonyms use the same security scheme as other Netezza Performance Server database objects. As the admin user, you have all privileges on synonyms and do not have to explicitly grant yourself privileges to manage them. The owner of the database has all privileges on all synonyms within the database. The synonym owner has all privileges on the synonym. To select from an object, the owner of the synonym must also have privileges to the referenced table, view, or function.

The following table lists the privilege rules for all other users:

Table 1. Synonym privileges
To run this command:	You need this privilege:
CREATE SYNONYM	Grant the user Create Synonym administration privilege.
ALTER SYNONYM	Grant the user Alter privilege for a synonym or the Synonym object class.
DROP SYNONYM	Grant the user Drop privilege for a synonym or the Synonym object class.
LIST synonyms	All users have List privilege by default and can see all synonyms.
SELECT synonyms	All users have Select privilege by default to select all synonyms.

You grant privileges to create, alter, and drop synonyms with the GRANT SYNONYM command.

The syntax for the GRANT SYNONYM command is:

GRANT [CREATE] SYNONYM TO user_or_group;
GRANT ALTER, DROP ON synonym_name TO user_or_group;

You revoke privileges to create, alter, and drop synonyms with the REVOKE SYNONYM command.

The syntax for the REVOKE SYNONYM command is:

REVOKE [CREATE] SYNONYM FROM user_or_group;
REVOKE ALTER, DROP ON synonym_name FROM user_or_group;