Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

9.4 -- Can SET ROLE be fired upon connection to engine?

Status
Not open for further replies.

masinger

Programmer
Aug 31, 2004
1
US
We are migrating from 7.3 to 9.4 and doing a little tightening up in the process. I'm not real familiar with the enhancements to 9.4 so I was wondering if there might be a way to get the SQL "SET ROLE name_of_role;" to fire upon connection to the engine (or at the establishment of a session) other than from the client-side application?

Thanks,
M.A. Singer
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top