DQ Internal Security › Securing Data Access for SQL Use › Using SYNONYM Access

Using SYNONYM Access

The use of a synonym provides an alternate name for a table. The synonym is a convenience that allows the user to avoid naming both the authorization ID and the table name (authid.tablename) in the query. It has no effect on security. The CREATE SYNONYM command names the authorization ID of the owner and the alternate table name. The other user accesses the table by using the alternate table name in his queries.