----- Original Message -----
> I haven't tried using these before, but I do notice that your > 'create role' syntax appears to be incorrect for this usage. > Sorry for the late reply, folks. Rugby World Cup got in the way... :D Yeah, found out what the problem was after all. I assumed that "authid definer" was redundant (which was the case I was trying to get to work), so I left it out of the statement. That caused the 6565 error. Once I put "authid current_user" or "authid definer" back in the statement, all was well. It appears that a SET ROLE only works in a procedure, IF one explicitly indicates the "authid" clause in the procedure (or package) creation. Without that, it's 6565. With it, all works fine. Go figure... Thanks a lot for all the help from all the replies, too many for me to thank individually. Now, to make this work with a login trigger... Cheers Nuno Souto [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nuno Souto INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
