Re: Can someone please verify this for me?

• 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
nsouto_at_optusnet.com.au

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Nuno Souto
  INET: nsouto_at_optusnet.com.au

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: ListGuru_at_fatcity.com (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).