Dynamic SET ROLE (Answer)

I feel really stupid....

The way in which I am able to dynamically set a role is via the built in:

     sys.dbms_session.set_role(role_name)

I had tried this from within my form prior to posing the question to the list and could not get it to work when the role_name was a variable (not within quotes). Turns out that I had MISSPELLED the variable!! (Like I said I really feel stupid, but I hope that someone else gained some knowlege about setting roles on the fly!) Received on Tue Jan 16 1996 - 11:00:05 CST