After you set up trusted sessions, logons by end users proceed as follows:
- An application defined as a trusted user logs on to Teradata Vantage as a permanent database user, and creates a connection pool.
- An application end user (defined as a proxy user) logs on and is authenticated by the application.
- The proxy user requests a service that requires access to Vantage.
- The application gets a connection from the pool and issues a SET QUERY_BAND, which identifies the PROXYUSER and sets the role and query band duration, establishing a trusted session.
- The database authorizes proxy user privileges in Vantage based on the roles assigned to the user.
- Vantage records the proxy user identity in all access and query log entries.
- A trusted session persists for the life of the query band.