The SET OWNER statement allows you to specify one or more owner names for use during the current database connection. An owner name is assigned only through the transactional interface, not through the relational interface. Note that no relationship exists between an owner name and any system user name or database user name. Think of an owner name as a simple file password that, if assigned, is required to access a data file.

In a database with security turned On, this command has no effect for most users. It only has an effect when it is issued by the Master user. If the Master user has not granted himself permissions yet, issuing this command gives the Master user full access to any data file with one of the specified owner names. Also, if the Master user chooses to give himself permissions, he has two options. The Master user can issue a SET OWNER followed by a GRANT without an owner name, or the Master user can issue a GRANT that specifies the owner name. See Examples.

or