Understanding the Terminology › Authorization ID (authid)

Authorization ID (authid)

Each user who works in SQL Mode has a special ID called the Private SQL Authorization ID. It is the user's default authorization ID for personal database and for all SQL Mode. If you change your SQL authorization ID with the PROFILE or AUTHID command, it changes only on the User Profile. If you create a personal table, your default authorization ID is attached to the table name regardless of the authid you were using when you created the table.