Microsoft query Assigning a user role

[achiacu]

I have an Excel spreadsheet that retrieves data from Oracle tables using microsoft query. I would like to assign the users a user role in the add property of the query tables object, or the command text property.

Here is my code:

ActiveSheet.QueryTables.Add(Connection:= _
"ODBC;DSN=volprd;SERVER=volprd;", Destination:=Range("A1"))
.CommandText = " SET ROLE PLACEMENT_USER"

Is it possible to specify a role in the .Add property above. or in the command text property. what i have now in the command text property does not work.